yes, we can insert null values into foreign key column. and we can also insert duplicate values into foreign key column which are there in unique key column or primary key column.
Subscribe to:
Post Comments (Atom)
How to schedule PO workflow schedule process
create or replace PACKAGE APPS.XXXX_PO_WF_SCHEDULING_PKG IS --|==========================================================================...
-
--Query used to display the Order details and its invoice details select ooh.ORDER_NUMBER "Order Number" , ra.C...
-
--Open PO query. SELECT pha.segment1 ponumber, hou.name organization_code, pha.type_lookup_code potype, trunc(pha.cre...
-
-- Open PO Receipts. SELECT h.receipt_num ,h.shipment_header_id ,l.SHIPMENT_LINE_STATUS_CODE ,pha.segment1 PO_N...
No comments:
Post a Comment