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_LINES_ALL

Line 1424: FROM PO_LINES_ALL POL,

1420: POL.CLM_UDA_PRICING_TOTAL, --UCA PRoject End
1421: POL.CLM_PAYMENT_INSTR_CODE, --
1422: POL.CLM_EXHIBIT_NAME -- Elins project
1423:
1424: FROM PO_LINES_ALL POL,
1425: PO_LINES_ARCHIVE_ALL POLA
1426: WHERE POL.po_header_id = p_document_id
1427: AND POL.po_line_id = POLA.po_line_id (+)
1428: AND POLA.latest_external_flag (+) = 'Y'

Line 2859: FROM PO_LINES_ALL

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
2860: WHERE po_header_id = p_document_id)))
2861: AND POR.entity_type = p_entity_type
2862: AND POR.price_differential_id = PORA.price_differential_id (+)
2863: AND PORA.latest_external_flag (+) = 'Y'

Line 2903: FROM PO_LINES_ALL

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
2904: WHERE po_header_id = p_document_id)))
2905: AND entity_type = p_entity_type
2906: AND latest_external_flag = 'Y'
2907: AND revision_num < p_revision_num

Line 3971: l_po_line_id po_lines_all.po_line_id%type;

3967: cursor c is select po_line_id from po_lines_archive_all
3968: where po_header_id = p_po_header_id
3969: and revision_num = p_revision_num;
3970:
3971: l_po_line_id po_lines_all.po_line_id%type;
3972:
3973: BEGIN
3974: l_progress := '000';
3975:

Line 4652: PO_LINES_ALL POL

4648: ATTR.last_updated_program,
4649: 'Y', -- latest_external_flag
4650: ATTR.PICTURE --
4651: FROM PO_ATTRIBUTE_VALUES ATTR,
4652: PO_LINES_ALL POL
4653: WHERE ATTR.po_line_id = POL.po_line_id
4654: AND POL.po_header_id = p_po_header_id
4655: AND POL.po_line_id = l_po_line_id; -- bug 10349444
4656: end loop;

Line 4720: l_po_line_id po_lines_all.po_line_id%type;

4716: cursor c is select po_line_id from po_lines_archive_all
4717: where po_header_id = p_po_header_id
4718: and revision_num = p_revision_num;
4719:
4720: l_po_line_id po_lines_all.po_line_id%type;
4721:
4722: BEGIN
4723: l_progress := '000';
4724:

Line 5095: PO_LINES_ALL POL

5091: TLP.program_id,
5092: TLP.program_update_date,
5093: TLP.last_updated_program
5094: FROM PO_ATTRIBUTE_VALUES_TLP TLP,
5095: PO_LINES_ALL POL
5096: WHERE TLP.po_line_id = POL.po_line_id
5097: AND POL.po_header_id = p_po_header_id
5098: AND pol.po_line_id = l_po_line_id; -- bug 10349444
5099: end loop;

Line 5379: PO_LINES_ALL POL

5375: 'Y', -- latest_external_flag
5376: p_revision_num,
5377: ADJ.adj_line_num
5378: FROM PO_PRICE_ADJUSTMENTS ADJ,
5379: PO_LINES_ALL POL
5380: WHERE ADJ.po_line_id = POL.po_line_id
5381: AND POL.po_header_id = p_po_header_id;
5382:
5383: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into PRICE ADJUSTMENTS archive='||SQL%rowcount); END IF;

Line 5474: PO_LINES_ALL POL

5470: 'Y', -- latest_external_flag
5471: p_revision_num
5472: FROM PO_PRICE_ADJ_ATTRIBS ATTR,
5473: PO_PRICE_ADJUSTMENTS ADJ,
5474: PO_LINES_ALL POL
5475: WHERE ATTR.price_adjustment_id = ADJ.price_adjustment_id
5476: AND ADJ.po_line_id = POL.po_line_id
5477: AND POL.po_header_id = p_po_header_id;
5478:

Line 5497: -- PO_LINES_ALL_EXT_B_ARCHIVE / PO_LINES_ALL_EXT_TL_ARCHIVE

5493: --Pre-reqs:
5494: -- None.
5495: --Modifies:
5496: -- PO_HEADERS_ALL_EXT_B_ARCHIVE / PO_HEADERS_ALL_EXT_TL_ARCHIVE
5497: -- PO_LINES_ALL_EXT_B_ARCHIVE / PO_LINES_ALL_EXT_TL_ARCHIVE
5498: -- PO_LINE_LOC_ALL_EXT_B_ARCHIVE / PO_LINE_LOC_ALL_EXT_TL_ARCHIVE
5499: --Locks:
5500: -- None.
5501: --Function:

Line 5965: -- Start PO_LINES_ALL_EXT_B_ARCHIVE

5961: -- Archive UDA Line and Line Locations data only for PO or PA BLANKETS
5962: IF (p_document_type = 'PO') OR
5963: (p_document_type = 'PA' AND p_document_subtype='BLANKET') THEN
5964:
5965: -- Start PO_LINES_ALL_EXT_B_ARCHIVE
5966: l_progress := '070';
5967: IF PO_LOG.d_stmt THEN
5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');
5969: END IF;

Line 5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');

5964:
5965: -- Start PO_LINES_ALL_EXT_B_ARCHIVE
5966: l_progress := '070';
5967: IF PO_LOG.d_stmt THEN
5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');
5969: END IF;
5970:
5971: INSERT INTO PO_LINES_ALL_EXT_B_ARCHIVE
5972: (EXTENSION_ID

Line 5971: INSERT INTO PO_LINES_ALL_EXT_B_ARCHIVE

5967: IF PO_LOG.d_stmt THEN
5968: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_B');
5969: END IF;
5970:
5971: INSERT INTO PO_LINES_ALL_EXT_B_ARCHIVE
5972: (EXTENSION_ID
5973: ,ATTR_GROUP_ID
5974: ,PO_LINE_ID
5975: ,DATA_LEVEL_ID

Line 6190: FROM PO_LINES_ALL_EXT_B POLE,

6186: ,POLE.UDA_TEMPLATE_ID
6187: ,POLE.DRAFT_ID
6188: ,p_revision_num
6189: ,'Y'
6190: FROM PO_LINES_ALL_EXT_B POLE,
6191: PO_LINES_ALL POL, PO_LINES_ARCHIVE_ALL POLA
6192: WHERE POL.po_header_id = p_po_header_id
6193: AND POL.po_line_id = POLE.po_line_id
6194: AND POL.po_line_id = POLA.po_line_id (+)

Line 6191: PO_LINES_ALL POL, PO_LINES_ARCHIVE_ALL POLA

6187: ,POLE.DRAFT_ID
6188: ,p_revision_num
6189: ,'Y'
6190: FROM PO_LINES_ALL_EXT_B POLE,
6191: PO_LINES_ALL POL, PO_LINES_ARCHIVE_ALL POLA
6192: WHERE POL.po_header_id = p_po_header_id
6193: AND POL.po_line_id = POLE.po_line_id
6194: AND POL.po_line_id = POLA.po_line_id (+)
6195: AND Nvl(POL.revision_num,0) = p_revision_num

Line 6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');

6203:
6204: l_progress := '080';
6205: IF PO_LOG.d_stmt THEN
6206: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6208: END IF;
6209:
6210: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags
6211: UPDATE PO_LINES_ALL_EXT_B_ARCHIVE POL1

Line 6211: UPDATE PO_LINES_ALL_EXT_B_ARCHIVE POL1

6207: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6208: END IF;
6209:
6210: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags
6211: UPDATE PO_LINES_ALL_EXT_B_ARCHIVE POL1
6212: SET latest_external_flag = 'N'
6213: WHERE latest_external_flag = 'Y'
6214: AND revision_num < p_revision_num
6215: AND EXISTS

Line 6217: FROM PO_LINES_ALL_EXT_B_ARCHIVE POL2, PO_LINES_ARCHIVE_ALL PLA

6213: WHERE latest_external_flag = 'Y'
6214: AND revision_num < p_revision_num
6215: AND EXISTS
6216: (SELECT 'A new archived row'
6217: FROM PO_LINES_ALL_EXT_B_ARCHIVE POL2, PO_LINES_ARCHIVE_ALL PLA
6218: WHERE PLA.po_header_id = p_po_header_id
6219: AND PLA.po_line_id = POL1.po_line_id
6220: AND POL2.po_line_id = POL1.po_line_id
6221: AND POL2.latest_external_flag = 'Y'

Line 6230: -- End PO_LINES_ALL_EXT_B_ARCHIVE

6226: PO_LOG.stmt(d_mod,l_progress,'Number of rows updated: '||SQL%rowcount);
6227: END IF;
6228: END IF;
6229: --
6230: -- End PO_LINES_ALL_EXT_B_ARCHIVE
6231:
6232: -- Start PO_LINES_ALL_EXT_TL_ARCHIVE
6233: l_progress := '090';
6234: IF PO_LOG.d_stmt THEN

Line 6232: -- Start PO_LINES_ALL_EXT_TL_ARCHIVE

6228: END IF;
6229: --
6230: -- End PO_LINES_ALL_EXT_B_ARCHIVE
6231:
6232: -- Start PO_LINES_ALL_EXT_TL_ARCHIVE
6233: l_progress := '090';
6234: IF PO_LOG.d_stmt THEN
6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');
6236: END IF;

Line 6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');

6231:
6232: -- Start PO_LINES_ALL_EXT_TL_ARCHIVE
6233: l_progress := '090';
6234: IF PO_LOG.d_stmt THEN
6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');
6236: END IF;
6237:
6238: INSERT INTO PO_LINES_ALL_EXT_TL_ARCHIVE
6239: (EXTENSION_ID

Line 6238: INSERT INTO PO_LINES_ALL_EXT_TL_ARCHIVE

6234: IF PO_LOG.d_stmt THEN
6235: PO_LOG.stmt(d_mod,l_progress,'Archive PO_LINES_ALL_EXT_TL');
6236: END IF;
6237:
6238: INSERT INTO PO_LINES_ALL_EXT_TL_ARCHIVE
6239: (EXTENSION_ID
6240: ,ATTR_GROUP_ID
6241: ,PO_LINE_ID
6242: ,DATA_LEVEL_ID

Line 6361: FROM PO_LINES_ALL_EXT_TL POLE,

6357: ,POLE.UDA_TEMPLATE_ID
6358: ,POLE.DRAFT_ID
6359: ,p_revision_num
6360: ,NULL
6361: FROM PO_LINES_ALL_EXT_TL POLE,
6362: PO_LINES_ALL POL
6363: WHERE POL.po_header_id = p_po_header_id
6364: AND POL.po_line_id = POLE.po_line_id
6365: AND POLE.draft_id = -1;

Line 6362: PO_LINES_ALL POL

6358: ,POLE.DRAFT_ID
6359: ,p_revision_num
6360: ,NULL
6361: FROM PO_LINES_ALL_EXT_TL POLE,
6362: PO_LINES_ALL POL
6363: WHERE POL.po_header_id = p_po_header_id
6364: AND POL.po_line_id = POLE.po_line_id
6365: AND POLE.draft_id = -1;
6366:

Line 6371: -- End PO_LINES_ALL_EXT_TL_ARCHIVE

6367: l_progress := '100';
6368: IF PO_LOG.d_stmt THEN
6369: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6370: END IF;
6371: -- End PO_LINES_ALL_EXT_TL_ARCHIVE
6372:
6373: -- Start PO_LINE_LOC_ALL_EXT_B_ARCHIVE
6374: l_progress := '110';
6375: IF PO_LOG.d_stmt THEN

Line 6614: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');

6610:
6611: l_progress := '120';
6612: IF PO_LOG.d_stmt THEN
6613: PO_LOG.stmt(d_mod,l_progress,'Number of rows inserted: '||SQL%rowcount);
6614: PO_LOG.stmt(d_mod,l_progress,'Update PO_LINES_ALL_EXT_B_ARCHIVE to reset latest_external_flag');
6615: END IF;
6616:
6617: -- If a row was inserted into PO_LINES_ARCHIVE, then set the appropriate flags
6618: UPDATE PO_LINE_LOC_ALL_EXT_B_ARCHIVE POL1

Line 6841: l_from_po_line_id PO_LINES_ALL.po_line_id%TYPE;

6837: l_progress VARCHAR2(4) := '000';
6838:
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;

Line 6852: FROM PO_LINES_ALL

6848: -- Cursor definitions:
6849:
6850: CURSOR po_line_cursor(p_po_header_id po_lines.po_header_id%TYPE) IS
6851: SELECT po_line_id
6852: FROM PO_LINES_ALL
6853: WHERE po_header_id = p_po_header_id
6854: ORDER BY line_num;
6855:
6856: CURSOR po_shipment_cursor(p_po_line_id po_line_locations.po_line_id%TYPE) IS