DBA Data[Home] [Help]

APPS.JAI_PO_DA_TRIGGER_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 21: --Using AutoCreate, AutoCreate inserts details into PO_HEADERS_ALL,PO_LINE_LOCATIONS_ALL,

17: --This trigger is used to default the taxes
18: --when Standard PO is created from a Standrad Requisition using AutoCreate.
19:
20: --When Standard PO is created from a Standard Requisition
21: --Using AutoCreate, AutoCreate inserts details into PO_HEADERS_ALL,PO_LINE_LOCATIONS_ALL,
22: -- PO_DISTRIBUTIONS_ALL
23:
24: --In PO_DISTRIBUTIONS_ALL , REQ_DISTRIBUTION_ID will be same as
25: --DISTRIBUTION_ID in PO_REQ_DISTRIBUTIONS_ALL and REQ_DISTRIBUTION_ID is inserted into

Line 102: FROM po_line_locations_all

98: WHERE Po_Header_Id = v_po_hdr_id;
99:
100: CURSOR Line_Loc_Cur( lineid IN NUMBER ) IS
101: SELECT Line_Location_Id
102: FROM po_line_locations_all
103: WHERE Po_Line_Id = lineid;
104:
105: -- End of addition
106: BEGIN