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_LINES_ALL

Line 150: DELETE FROM po_lines_all_ext_b

146: --Start Deleting UDA Atribs
147: DELETE FROM po_headers_all_ext_b
148: WHERE draft_id = p_draft_id;
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;

Line 159: DELETE FROM po_lines_all_ext_tl

155:
156: DELETE FROM po_headers_all_ext_tl
157: WHERE draft_id = p_draft_id;
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;

Line 2170: FROM PO_LINES_ALL

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
2171: WHERE po_header_id = p_document_id)))
2172: AND POR.entity_type = p_entity_type
2173: AND POR.revision_num = p_revision_num;
2174:

Line 2901: PO_LINES_ALL POL

2897: ATTR.program_application_id,
2898: ATTR.program_id,
2899: ATTR.program_update_date
2900: FROM PO_ATTR_VALUES_ARCHIVE ATTR,
2901: PO_LINES_ALL POL
2902: WHERE ATTR.po_line_id = POL.po_line_id
2903: AND POL.po_header_id = p_document_id
2904: AND ATTR.revision_num = p_revision_num;
2905:

Line 3325: PO_LINES_ALL POL

3321: TLP.program_application_id,
3322: TLP.program_id,
3323: TLP.program_update_date
3324: FROM PO_ATTR_VALUES_TLP_ARCHIVE TLP,
3325: PO_LINES_ALL POL
3326: WHERE TLP.po_line_id = POL.po_line_id
3327: AND POL.po_header_id = p_document_id
3328: AND TLP.revision_num = p_revision_num;
3329:

Line 3598: PO_LINES_ALL POL

3594: , ADJ.operand_per_pqty
3595: , ADJ.adjusted_amount_per_pqty
3596: , 1
3597: FROM PO_PRICE_ADJUSTMENTS_ARCHIVE ADJ,
3598: PO_LINES_ALL POL
3599: WHERE ADJ.po_line_id = POL.po_line_id
3600: AND POL.po_header_id = p_document_id
3601: AND ADJ.revision_num = p_revision_num;
3602:

Line 3709: PO_LINES_ALL POL

3705: , ATTR.price_adj_attrib_id
3706: , 1
3707: FROM PO_PRICE_ADJ_ATTRIBS_ARCHIVE ATTR,
3708: PO_PRICE_ADJUSTMENTS ADJ,
3709: PO_LINES_ALL POL
3710: WHERE ATTR.price_adjustment_id = ADJ.price_adjustment_id
3711: AND ADJ.po_line_id = POL.po_line_id
3712: AND POL.po_header_id = p_document_id
3713: AND ATTR.revision_num = p_revision_num;

Line 3885: -- PO_LINES_ALL_EXT_B / PO_LINES_ALL_EXT_TL

3881: --Name: SYNC_UDA_ATTRIBS
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:

Line 3945: FROM PO_LINES_ALL_EXT_B_ARCHIVE POLE,

3941: AND revision_num = p_revision_num;
3942:
3943: CURSOR po_lines_ext_cursor IS
3944: SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL
3945: FROM PO_LINES_ALL_EXT_B_ARCHIVE POLE,
3946: PO_LINES_ALL POL
3947: WHERE POL.po_header_id = p_document_id
3948: AND POL.po_line_id = POLE.po_line_id
3949: AND POLE.draft_id = -1

Line 3946: PO_LINES_ALL POL

3942:
3943: CURSOR po_lines_ext_cursor IS
3944: SELECT POLE.extension_id, EGO_EXTFWK_S.NEXTVAL
3945: FROM PO_LINES_ALL_EXT_B_ARCHIVE POLE,
3946: PO_LINES_ALL POL
3947: WHERE POL.po_header_id = p_document_id
3948: AND POL.po_line_id = POLE.po_line_id
3949: AND POLE.draft_id = -1
3950: AND POLE.revision_num = p_revision_num;

Line 4390: -- Start PO_LINES_ALL_EXT_B

4386: OPEN po_lines_ext_cursor;
4387: FETCH po_lines_ext_cursor BULK COLLECT INTO l_old_line_ext_id_tbl, l_new_line_ext_id_tbl;
4388: CLOSE po_lines_ext_cursor;
4389:
4390: -- Start PO_LINES_ALL_EXT_B
4391: d_position := 80;
4392: IF PO_LOG.d_stmt THEN
4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');
4394: END IF;

Line 4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');

4389:
4390: -- Start PO_LINES_ALL_EXT_B
4391: d_position := 80;
4392: IF PO_LOG.d_stmt THEN
4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');
4394: END IF;
4395:
4396: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4397: INSERT INTO PO_LINES_ALL_EXT_B

Line 4397: INSERT INTO PO_LINES_ALL_EXT_B

4393: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_B');
4394: END IF;
4395:
4396: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4397: INSERT INTO PO_LINES_ALL_EXT_B
4398: (EXTENSION_ID
4399: ,ATTR_GROUP_ID
4400: ,PO_LINE_ID
4401: ,DATA_LEVEL_ID

Line 4612: FROM PO_LINES_ALL_EXT_B_ARCHIVE

4608: ,D_EXT_ATTR9
4609: ,D_EXT_ATTR10
4610: ,UDA_TEMPLATE_ID
4611: ,p_draft_id
4612: FROM PO_LINES_ALL_EXT_B_ARCHIVE
4613: WHERE extension_id = l_old_line_ext_id_tbl(i)
4614: AND revision_num = p_revision_num;
4615:
4616: d_position := 90;

Line 4620: -- End PO_LINES_ALL_EXT_B

4616: d_position := 90;
4617: IF PO_LOG.d_stmt THEN
4618: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4619: END IF;
4620: -- End PO_LINES_ALL_EXT_B
4621:
4622: -- Start PO_LINES_ALL_EXT_TL
4623: d_position := 100;
4624: IF PO_LOG.d_stmt THEN

Line 4622: -- Start PO_LINES_ALL_EXT_TL

4618: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4619: END IF;
4620: -- End PO_LINES_ALL_EXT_B
4621:
4622: -- Start PO_LINES_ALL_EXT_TL
4623: d_position := 100;
4624: IF PO_LOG.d_stmt THEN
4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');
4626: END IF;

Line 4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');

4621:
4622: -- Start PO_LINES_ALL_EXT_TL
4623: d_position := 100;
4624: IF PO_LOG.d_stmt THEN
4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');
4626: END IF;
4627:
4628: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4629: INSERT INTO PO_LINES_ALL_EXT_TL

Line 4629: INSERT INTO PO_LINES_ALL_EXT_TL

4625: PO_LOG.stmt(d_mod,d_position,'Sync PO_LINES_ALL_EXT_TL');
4626: END IF;
4627:
4628: FORALL i IN 1..l_old_line_ext_id_tbl.Count
4629: INSERT INTO PO_LINES_ALL_EXT_TL
4630: (EXTENSION_ID
4631: ,ATTR_GROUP_ID
4632: ,PO_LINE_ID
4633: ,DATA_LEVEL_ID

Line 4748: FROM PO_LINES_ALL_EXT_TL_ARCHIVE

4744: ,TL_EXT_ATTR39
4745: ,TL_EXT_ATTR40
4746: ,UDA_TEMPLATE_ID
4747: ,p_draft_id
4748: FROM PO_LINES_ALL_EXT_TL_ARCHIVE
4749: WHERE extension_id = l_old_line_ext_id_tbl(i)
4750: AND language = userenv('LANG')
4751: AND revision_num = p_revision_num;
4752:

Line 4757: -- End PO_LINES_ALL_EXT_TL

4753: d_position := 110;
4754: IF PO_LOG.d_stmt THEN
4755: PO_LOG.stmt(d_mod,d_position,'Number of rows inserted: '||SQL%rowcount);
4756: END IF;
4757: -- End PO_LINES_ALL_EXT_TL
4758:
4759: OPEN po_line_loc_ext_cursor;
4760: FETCH po_line_loc_ext_cursor BULK COLLECT INTO l_old_line_loc_ext_id_tbl, l_new_line_loc_ext_id_tbl;
4761: CLOSE po_line_loc_ext_cursor;