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
/
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
/
https://www.oracle.com/middleware/techn ... loads.html
Sample Template