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_R12_CAT_UPG_PVT dependencies on PO_LINES_INTERFACE

Line 2841: FROM po_lines_interface lines

2837: NULL, -- org_id: Not present in interface tables. Just initialize the collection
2838: NULL, -- order_type_lookup_code: Not present in interface tables. Just initialize the collection
2839: NULL, -- purchase_basis: Not present in interface tables. Just initialize the collection
2840: NULL -- matching_basis: Not present in interface tables. Just initialize the collection
2841: FROM po_lines_interface lines
2842: WHERE lines.processing_id = request_processing_id
2843: AND lines.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
2844: AND lines.action IN (PO_R12_CAT_UPG_PVT.g_action_line_create, 'UPDATE', 'DELETE');
2845:

Line 3948: UPDATE PO_LINES_INTERFACE

3944: -- line creation.
3945: -- SQL Why : To make it available to the calling program of the migration API.
3946: -- SQL Join: interface_line_id
3947: FORALL i IN 1 .. l_valid_lines.po_line_id.COUNT
3948: UPDATE PO_LINES_INTERFACE
3949: SET PO_LINE_ID = l_valid_lines.po_line_id(i),
3950: PROCESS_CODE = g_PROCESS_CODE_PROCESSED
3951: WHERE interface_line_id = l_valid_lines.interface_line_id(i);
3952:

Line 4115: UPDATE po_lines_interface

4111: -- SQL What: Update the process_code of lines interface rows with PROCESSED
4112: -- SQL Why : To mark them as successfully updated
4113: -- SQL Join: interface_line_id
4114: FORALL i IN 1..p_doc_lines_rec.po_line_id.COUNT
4115: UPDATE po_lines_interface
4116: SET PROCESS_CODE = g_PROCESS_CODE_PROCESSED
4117: WHERE interface_line_id = p_doc_lines_rec.interface_line_id(i)
4118: AND p_doc_lines_rec.has_errors(i) = 'N'
4119: AND p_doc_lines_rec.action(i) = 'UPDATE';

Line 4201: UPDATE po_lines_interface

4197:
4198: l_progress := '040';
4199: -- Mark interface lines as PROCESSED
4200: FORALL i IN 1..p_doc_lines_rec.po_line_id.COUNT
4201: UPDATE po_lines_interface
4202: SET PROCESS_CODE = g_PROCESS_CODE_PROCESSED
4203: WHERE interface_line_id = p_doc_lines_rec.interface_line_id(i)
4204: AND p_doc_lines_rec.has_errors(i) = 'N'
4205: AND p_doc_lines_rec.action(i) = 'DELETE';

Line 4260: -- The po_line_id would be stamped on PO_LINES_INTERFACE for successfully migrated lines

4256: attrib.interface_header_id,
4257: attrib.interface_line_id,
4258: attrib.action,
4259: attrib.process_code,
4260: -- The po_line_id would be stamped on PO_LINES_INTERFACE for successfully migrated lines
4261: NVL(DECODE(attrib.po_line_id,
4262: g_NOT_REQUIRED_ID, POLI.po_line_id,
4263: NULL, POLI.po_line_id,
4264: attrib.po_line_id),

Line 4591: PO_LINES_INTERFACE POLI

4587: attrib.program_update_date,
4588: attrib.processing_id,
4589: 'N' -- has_errors
4590: FROM PO_ATTR_VALUES_INTERFACE attrib,
4591: PO_LINES_INTERFACE POLI
4592: WHERE attrib.processing_id = request_processing_id
4593: AND attrib.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
4594: AND attrib.action IN (PO_R12_CAT_UPG_PVT.g_action_attr_create, 'UPDATE', 'DELETE')
4595: AND attrib.interface_line_id = POLI.interface_line_id;

Line 5772: PO_LINES_INTERFACE POLI -- ECO bug 4738058

5768: p_attr_values_tbl.program_id(i),
5769: p_attr_values_tbl.program_update_date(i),
5770: g_R12_MIGRATION_PROGRAM -- last_updated_program
5771: FROM PO_ATTR_VALUES_INTERFACE POAVI,
5772: PO_LINES_INTERFACE POLI -- ECO bug 4738058
5773: WHERE POAVI.interface_attr_values_id = p_attr_values_tbl.interface_attr_values_id(i)
5774: AND p_attr_values_tbl.has_errors(i) = 'N'
5775: AND p_attr_values_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_attr_create
5776: -- ECO bug 4738058

Line 5792: FROM PO_LINES_INTERFACE POLI

5788: SET /*+ INDEX(POAVI, PO_ATTR_VALUES_INT_U1)*/
5789: process_code = g_PROCESS_CODE_PROCESSED
5790: -- ECO bug 4738058
5791: , po_line_id = (SELECT POLI.po_line_id
5792: FROM PO_LINES_INTERFACE POLI
5793: WHERE POLI.interface_line_id = POAVI.interface_line_id)
5794: WHERE POAVI.interface_attr_values_id = p_attr_values_tbl.interface_attr_values_id(i)
5795: AND p_attr_values_tbl.has_errors(i) = 'N'
5796: AND p_attr_values_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_attr_create;

Line 6335: -- The po_line_id would be stamped on PO_LINES_INTERFACE for successfully migrated lines

6331: attrib_tlp.interface_header_id,
6332: attrib_tlp.interface_line_id,
6333: attrib_tlp.action,
6334: attrib_tlp.process_code,
6335: -- The po_line_id would be stamped on PO_LINES_INTERFACE for successfully migrated lines
6336: NVL(DECODE(attrib_tlp.po_line_id,
6337: g_NOT_REQUIRED_ID, POLI.po_line_id,
6338: NULL, POLI.po_line_id,
6339: attrib_tlp.po_line_id),

Line 6514: PO_LINES_INTERFACE POLI

6510: attrib_tlp.program_update_date,
6511: attrib_tlp.processing_id,
6512: 'N' -- has_errors
6513: FROM PO_ATTR_VALUES_TLP_INTERFACE attrib_tlp,
6514: PO_LINES_INTERFACE POLI
6515: WHERE attrib_tlp.processing_id = request_processing_id
6516: AND attrib_tlp.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW
6517: AND attrib_tlp.action IN (PO_R12_CAT_UPG_PVT.g_action_tlp_create, 'UPDATE', 'DELETE')
6518: AND attrib_tlp.interface_line_id = POLI.interface_line_id;

Line 7225: PO_LINES_INTERFACE POLI -- ECO bug 4738058

7221: p_attr_values_tlp_tbl.program_id(i),
7222: p_attr_values_tlp_tbl.program_update_date(i),
7223: g_R12_MIGRATION_PROGRAM -- last_updated_program
7224: FROM PO_ATTR_VALUES_TLP_INTERFACE POAVTI,
7225: PO_LINES_INTERFACE POLI -- ECO bug 4738058
7226: WHERE POAVTI.interface_attr_values_tlp_id = p_attr_values_tlp_tbl.interface_attr_values_tlp_id(i)
7227: AND p_attr_values_tlp_tbl.has_errors(i) = 'N'
7228: AND p_attr_values_tlp_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_tlp_create
7229: -- ECO bug 4738058

Line 7245: FROM PO_LINES_INTERFACE POLI

7241: SET /*+ INDEX(POAVTI, PO_ATTR_VALUES_TLP_INT_U1)*/
7242: process_code = g_PROCESS_CODE_PROCESSED
7243: -- ECO bug 4738058
7244: , po_line_id = (SELECT POLI.po_line_id
7245: FROM PO_LINES_INTERFACE POLI
7246: WHERE POLI.interface_line_id = POAVTI.interface_line_id)
7247: WHERE POAVTI.interface_attr_values_tlp_id = p_attr_values_tlp_tbl.interface_attr_values_tlp_id(i)
7248: AND p_attr_values_tlp_tbl.has_errors(i) = 'N'
7249: AND p_attr_values_tlp_tbl.action(i) = PO_R12_CAT_UPG_PVT.g_action_tlp_create;

Line 7826: UPDATE PO_LINES_INTERFACE

7822: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of RT updated='||SQL%rowcount); END IF;
7823:
7824: -- Now update the upper level Line and Header Records to mark them PROCESSED
7825: FORALL i IN 1..p_rt_lines_rec.interface_attr_values_tlp_id.COUNT
7826: UPDATE PO_LINES_INTERFACE
7827: SET PROCESS_CODE = g_PROCESS_CODE_PROCESSED
7828: WHERE interface_line_id = p_rt_lines_rec.interface_line_id(i);
7829:
7830: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of LinesInterface rows marked PROCESSED='||SQL%rowcount); END IF;