eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 153: DELETE FROM po_line_locations_all_ext_b

149:
150: DELETE FROM po_lines_all_ext_b
151: WHERE draft_id = p_draft_id;
152:
153: DELETE FROM po_line_locations_all_ext_b
154: WHERE draft_id = p_draft_id;
155:
156: DELETE FROM po_headers_all_ext_tl
157: WHERE draft_id = p_draft_id;

Line 162: DELETE FROM po_line_locations_all_ext_tl

158:
159: DELETE FROM po_lines_all_ext_tl
160: WHERE draft_id = p_draft_id;
161:
162: DELETE FROM po_line_locations_all_ext_tl
163: WHERE draft_id = p_draft_id;
164: --End Deleting UDA Atribs
165:
166: --Deleting from po_ga_org_assign_draft

Line 2166: FROM PO_LINE_LOCATIONS_ALL

2162: last_update_login
2163: FROM po_price_differentials_archive POR
2164: WHERE ((p_entity_type = 'PRICE BREAK' AND
2165: POR.entity_id IN (SELECT line_location_id
2166: FROM PO_LINE_LOCATIONS_ALL
2167: WHERE po_header_id = p_document_id)) OR
2168: (p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
2169: POR.entity_id IN (SELECT po_line_id
2170: FROM PO_LINES_ALL

Line 3886: -- PO_LINE_LOCATIONS_ALL_EXT_B / PO_LINE_LOCATIONS_ALL_EXT_TL

3882: --Pre-reqs: None
3883: --Modifies:
3884: -- PO_HEADERS_ALL_EXT_B / PO_HEADERS_ALL_EXT_TL
3885: -- PO_LINES_ALL_EXT_B / PO_LINES_ALL_EXT_TL
3886: -- PO_LINE_LOCATIONS_ALL_EXT_B / PO_LINE_LOCATIONS_ALL_EXT_TL
3887: --Locks:
3888: -- None.
3889: --Function:
3890: -- Sync UDA Data from Archive to Transaction Table

Line 3955: PO_LINE_LOCATIONS_ALL POL

3951:
3952: CURSOR po_line_loc_ext_cursor IS
3953: SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL
3954: FROM PO_LINE_LOC_ALL_EXT_B_ARCHIVE POLE,
3955: PO_LINE_LOCATIONS_ALL POL
3956: WHERE POL.po_header_id = p_document_id
3957: AND POL.line_location_id = POLE.line_location_id
3958: AND POLE.draft_id = -1
3959: AND POLE.revision_num = p_revision_num;

Line 4766: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_B');

4762:
4763: -- Start PO_LINE_LOC_ALL_EXT_B
4764: d_position := 120;
4765: IF PO_LOG.d_stmt THEN
4766: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_B');
4767: END IF;
4768:
4769: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
4770: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_B

Line 4770: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_B

4766: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_B');
4767: END IF;
4768:
4769: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
4770: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_B
4771: (EXTENSION_ID
4772: ,ATTR_GROUP_ID
4773: ,LINE_LOCATION_ID
4774: ,DATA_LEVEL_ID

Line 4998: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_TL');

4994:
4995: -- Start PO_LINE_LOC_ALL_EXT_TL
4996: d_position := 140;
4997: IF PO_LOG.d_stmt THEN
4998: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_TL');
4999: END IF;
5000:
5001: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
5002: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_TL

Line 5002: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_TL

4998: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINE_LOCATIONS_ALL_EXT_TL');
4999: END IF;
5000:
5001: FORALL i IN 1..l_old_line_loc_ext_id_tbl.Count
5002: INSERT INTO PO_LINE_LOCATIONS_ALL_EXT_TL
5003: (EXTENSION_ID
5004: ,ATTR_GROUP_ID
5005: ,LINE_LOCATION_ID
5006: ,DATA_LEVEL_ID