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_ATTR_VALUES_TLP_INTERFACE

Line 6513: FROM PO_ATTR_VALUES_TLP_INTERFACE attrib_tlp,

6509: attrib_tlp.program_id,
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')

Line 7224: FROM PO_ATTR_VALUES_TLP_INTERFACE POAVTI,

7220: p_attr_values_tlp_tbl.program_application_id(i),
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

Line 7240: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POAVTI

7236: -- SQL Why : To mark the rows as successfully inserted
7237: -- SQL Join: interface_attr_values_tlp_id
7238: -- Bug 5677911: Added the hint for performance reason.
7239: FORALL i IN 1..p_attr_values_tlp_tbl.po_line_id.COUNT
7240: UPDATE PO_ATTR_VALUES_TLP_INTERFACE POAVTI
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

Line 7499: PO_ATTR_VALUES_TLP_INTERFACE POTLPI

7495: -- attr/attr_tlp interface tables
7496: -- Bug 5677911: Added the hint for performance reason.
7497: FORALL i IN 1..p_attr_values_tlp_tbl.po_line_id.COUNT
7498: UPDATE /*+ INDEX(POTLPI, PO_ATTR_VALUES_TLP_INT_N3)*/
7499: PO_ATTR_VALUES_TLP_INTERFACE POTLPI
7500: SET PROCESS_CODE = g_PROCESS_CODE_PROCESSED
7501: WHERE p_attr_values_tlp_tbl.has_errors(i) = 'N'
7502: AND p_attr_values_tlp_tbl.action(i) = 'UPDATE'
7503: AND language = p_attr_values_tlp_tbl.language(i)

Line 7574: PO_ATTR_VALUES_TLP_INTERFACE POTLPI

7570: -- Delete Rows that do not have errors
7571: -- Bug 5677911: Added the hint for performance reason.
7572: FORALL i IN 1..p_attr_values_tlp_tbl.po_line_id.COUNT
7573: UPDATE /*+ INDEX(POTLPI, PO_ATTR_VALUES_TLP_INT_N3)*/
7574: PO_ATTR_VALUES_TLP_INTERFACE POTLPI
7575: SET PROCESS_CODE = g_PROCESS_CODE_PROCESSED
7576: WHERE p_attr_values_tlp_tbl.has_errors(i) = 'N'
7577: AND p_attr_values_tlp_tbl.action(i) = 'DELETE'
7578: AND language = p_attr_values_tlp_tbl.language(i)

Line 7666: FROM PO_ATTR_VALUES_TLP_INTERFACE intf_tlp

7662: intf_tlp.req_template_line_num,
7663: intf_tlp.org_id,
7664: intf_tlp.ip_category_id,
7665: intf_tlp.description
7666: FROM PO_ATTR_VALUES_TLP_INTERFACE intf_tlp
7667: -- Not negative, means it was migrated successfully in prev steps
7668: WHERE intf_tlp.processing_id = p_request_processing_id
7669: AND intf_tlp.process_code = g_PROCESS_CODE_PROCESSED
7670: AND intf_tlp.action IN (PO_R12_CAT_UPG_PVT.g_action_tlp_create, 'UPDATE')