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_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 2020: FROM PO_LINE_LOCATIONS_ALL POL,

2016: ,POL.CLM_PROMISE_PERIOD
2017: ,POL.CLM_PROMISE_PERIOD_UOM
2018: ,POL.CLM_POP_DURATION
2019: ,POL.CLM_POP_DURATION_UOM
2020: FROM PO_LINE_LOCATIONS_ALL POL,
2021: PO_LINE_LOCATIONS_ARCHIVE_ALL POLA
2022: WHERE ((p_document_type = 'RELEASE' AND
2023: POL.po_release_id = p_document_id) OR
2024: (p_document_type <> 'RELEASE' AND -- Bug 3210749

Line 2855: FROM PO_LINE_LOCATIONS_ALL

2851: FROM PO_PRICE_DIFFERENTIALS POR,
2852: PO_PRICE_DIFFERENTIALS_ARCHIVE PORA
2853: WHERE ((p_entity_type = 'PRICE BREAK' AND
2854: POR.entity_id IN (SELECT line_location_id
2855: FROM PO_LINE_LOCATIONS_ALL
2856: WHERE po_header_id = p_document_id)) OR
2857: (p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
2858: POR.entity_id IN (SELECT po_line_id
2859: FROM PO_LINES_ALL

Line 2899: FROM PO_LINE_LOCATIONS_ALL

2895: UPDATE PO_PRICE_DIFFERENTIALS_ARCHIVE POR1
2896: SET latest_external_flag = 'N'
2897: WHERE ((p_entity_type = 'PRICE BREAK' AND
2898: entity_id IN (SELECT line_location_id
2899: FROM PO_LINE_LOCATIONS_ALL
2900: WHERE po_header_id = p_document_id)) OR
2901: (p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
2902: entity_id IN (SELECT po_line_id
2903: FROM PO_LINES_ALL

Line 6376: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_B');

6372:
6373: -- Start PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6374: l_progress := '110';
6375: IF PO_LOG.d_stmt THEN
6376: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_B');
6377: END IF;
6378:
6379: INSERT INTO PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6380: (EXTENSION_ID

Line 6598: FROM PO_LINE_LOCATIONS_ALL_EXT_B POLE,

6594: ,POLE.UDA_TEMPLATE_ID
6595: ,POLE.DRAFT_ID
6596: ,p_revision_num
6597: ,'Y' --
6598: FROM PO_LINE_LOCATIONS_ALL_EXT_B POLE,
6599: PO_LINE_LOCATIONS_ALL POL, PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
6600: --
6601: WHERE POL.po_header_id = p_po_header_id
6602: AND POL.line_location_id = POLE.line_location_id

Line 6599: PO_LINE_LOCATIONS_ALL POL, PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

6595: ,POLE.DRAFT_ID
6596: ,p_revision_num
6597: ,'Y' --
6598: FROM PO_LINE_LOCATIONS_ALL_EXT_B POLE,
6599: PO_LINE_LOCATIONS_ALL POL, PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA
6600: --
6601: WHERE POL.po_header_id = p_po_header_id
6602: AND POL.line_location_id = POLE.line_location_id
6603: AND POL.line_location_id = POLLA.line_location_id (+)

Line 6642: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_TL');

6638:
6639: -- Start PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6640: l_progress := '130';
6641: IF PO_LOG.d_stmt THEN
6642: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINE_LOCATIONS_ALL_EXT_TL');
6643: END IF;
6644:
6645: INSERT INTO PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
6646: (EXTENSION_ID

Line 6768: FROM PO_LINE_LOCATIONS_ALL_EXT_TL POLE,

6764: ,POLE.UDA_TEMPLATE_ID
6765: ,POLE.DRAFT_ID
6766: ,p_revision_num
6767: ,NULL
6768: FROM PO_LINE_LOCATIONS_ALL_EXT_TL POLE,
6769: PO_LINE_LOCATIONS_ALL POL
6770: WHERE POL.po_header_id = p_po_header_id
6771: AND POL.line_location_id = POLE.line_location_id
6772: AND POLE.draft_id = -1;

Line 6769: PO_LINE_LOCATIONS_ALL POL

6765: ,POLE.DRAFT_ID
6766: ,p_revision_num
6767: ,NULL
6768: FROM PO_LINE_LOCATIONS_ALL_EXT_TL POLE,
6769: PO_LINE_LOCATIONS_ALL POL
6770: WHERE POL.po_header_id = p_po_header_id
6771: AND POL.line_location_id = POLE.line_location_id
6772: AND POLE.draft_id = -1;
6773:

Line 6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;

6839: l_from_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
6840: l_to_po_header_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6841: l_from_po_line_id PO_LINES_ALL.po_line_id%TYPE;
6842: l_to_po_line_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6843: l_from_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
6844: l_to_line_location_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6845: l_from_po_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
6846: l_to_po_distribution_id FND_ATTACHED_DOCUMENTS.pk2_value%TYPE;
6847:

Line 6858: FROM PO_LINE_LOCATIONS_ALL

6854: ORDER BY line_num;
6855:
6856: CURSOR po_shipment_cursor(p_po_line_id po_line_locations.po_line_id%TYPE) IS
6857: SELECT line_location_id
6858: FROM PO_LINE_LOCATIONS_ALL
6859: WHERE po_line_id = p_po_line_id
6860: ORDER BY shipment_num;
6861:
6862: CURSOR po_distribution_cursor(p_line_location_id po_distributions.line_location_id%TYPE) IS