Master Detail Report using XML Desktop Publisher

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Master Detail Report using XML Desktop Publisher

Post by admin »

In this topic all scripts and details related to developing a master-detail report in Oracle APEX.

Register free at https://apex.oracle.com/

PO Header Table

Code: Select all

CREATE TABLE  "PO_HEADERS_ALL" 
   (	"PO_HEADER_ID" NUMBER, 
	"VENDOR_NAME" VARCHAR2(100), 
	"VENDOR_SITE_NAME" VARCHAR2(100), 
	"VENDOR_CONTACT_NAME" VARCHAR2(100), 
	"SHIP_TO_LOCATION" VARCHAR2(100), 
	"BILL_TO_LOCATION" VARCHAR2(100), 
	"TERMS_CODE" VARCHAR2(100), 
	"PO_DATE" DATE, 
	"PO_NUMBER" VARCHAR2(20), 
	"CURRENCY" VARCHAR2(10), 
	 PRIMARY KEY ("PO_HEADER_ID")
  USING INDEX  ENABLE
   )
/

 CREATE SEQUENCE   "PO_HEADERS_ALL_S"  MINVALUE 1 INCREMENT BY 1 START WITH 3 NOCACHE  NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL
/

CREATE OR REPLACE EDITIONABLE TRIGGER  "PO_HEADERS_ALL_BIU" 
  before insert or update ON PO_HEADERS_ALL
  for each row
begin  
    if inserting then 
    select PO_HEADERS_ALL_S.nextval into :new.PO_HEADER_ID from dual;
    end if; 
end;

/
ALTER TRIGGER  "PO_HEADERS_ALL_BIU" ENABLE
/

PO Detail Table

Code: Select all

CREATE TABLE  "PO_LINES_ALL" 
   (	"PO_LINE_ID" NUMBER, 
	"PO_HEADER_ID" NUMBER NOT NULL ENABLE, 
	"LINE_NUM" NUMBER NOT NULL ENABLE, 
	"ITEM_CODE" VARCHAR2(100), 
	"ITEM_DESCRIPTION" VARCHAR2(240), 
	"UOM" VARCHAR2(32), 
	"UNIT_PRICE" NUMBER, 
	"QUANTITY" NUMBER, 
	"AMOUNT" NUMBER, 
	 PRIMARY KEY ("PO_LINE_ID")
  USING INDEX  ENABLE
   )
/
ALTER TABLE  "PO_LINES_ALL" ADD CONSTRAINT "PO_HEADERS_FK" FOREIGN KEY ("PO_HEADER_ID")
	  REFERENCES  "PO_HEADERS_ALL" ("PO_HEADER_ID") ENABLE
/

 CREATE SEQUENCE   "PO_LINES_ALL_S"  MINVALUE 1 INCREMENT BY 1 START WITH 20 NOCACHE  NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL
/

CREATE OR REPLACE EDITIONABLE TRIGGER  "PO_LINES_ALL_BIU" 
  before insert or update ON PO_LINES_ALL
  for each row
begin  
    if inserting then 
    select PO_LINES_ALL_S.nextval into :new.PO_LINE_ID from dual;
    end if; 
end;

/
ALTER TRIGGER  "PO_LINES_ALL_BIU" ENABLE
/

Oracle Analytics Publisher Download
https://www.oracle.com/middleware/techn ... loads.html

Sample Template
js_report erpstuff.com.zip
You do not have the required permissions to view the files attached to this post.
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests