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_AUTO_LINE_PROCESS_PVT dependencies on PO_ATTR_VALUES_TLP_INTERFACE

Line 3603: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table

3599: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,p_message=>'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL% rowcount);
3600: END IF;
3601:
3602: l_progress:='010';
3603: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table
3604: --SQL Why : To facilitate bulk update of attributes, later in the flow
3605: --SQL Join: interface_header_id, interface_line_id
3606: FORALL i IN p_lines.po_line_id_tbl.FIRST.. p_lines.po_line_id_tbl.LAST
3607: UPDATE PO_ATTR_VALUES_TLP_INTERFACE

Line 3607: UPDATE PO_ATTR_VALUES_TLP_INTERFACE

3603: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table
3604: --SQL Why : To facilitate bulk update of attributes, later in the flow
3605: --SQL Join: interface_header_id, interface_line_id
3606: FORALL i IN p_lines.po_line_id_tbl.FIRST.. p_lines.po_line_id_tbl.LAST
3607: UPDATE PO_ATTR_VALUES_TLP_INTERFACE
3608: SET po_line_id = p_lines.po_line_id_tbl(i),
3609: req_template_name = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3610: req_template_line_num = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3611: inventory_item_id = NVL(inventory_item_id, g_ATTR_VALUES_NULL_ID)

Line 3612: WHERE po_attr_values_tlp_interface.interface_header_id = p_lines.intf_header_id_tbl(i)

3608: SET po_line_id = p_lines.po_line_id_tbl(i),
3609: req_template_name = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3610: req_template_line_num = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3611: inventory_item_id = NVL(inventory_item_id, g_ATTR_VALUES_NULL_ID)
3612: WHERE po_attr_values_tlp_interface.interface_header_id = p_lines.intf_header_id_tbl(i)
3613: AND po_attr_values_tlp_interface.interface_line_id = p_lines.intf_line_id_tbl(i);
3614:
3615: IF g_debug_stmt THEN
3616: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,

Line 3613: AND po_attr_values_tlp_interface.interface_line_id = p_lines.intf_line_id_tbl(i);

3609: req_template_name = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3610: req_template_line_num = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3611: inventory_item_id = NVL(inventory_item_id, g_ATTR_VALUES_NULL_ID)
3612: WHERE po_attr_values_tlp_interface.interface_header_id = p_lines.intf_header_id_tbl(i)
3613: AND po_attr_values_tlp_interface.interface_line_id = p_lines.intf_line_id_tbl(i);
3614:
3615: IF g_debug_stmt THEN
3616: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,
3617: p_message=>'Number of PO_ATTR_VALUES_TLP_INTERFACE rows updated='||SQL% rowcount);

Line 3617: p_message=>'Number of PO_ATTR_VALUES_TLP_INTERFACE rows updated='||SQL% rowcount);

3613: AND po_attr_values_tlp_interface.interface_line_id = p_lines.intf_line_id_tbl(i);
3614:
3615: IF g_debug_stmt THEN
3616: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,
3617: p_message=>'Number of PO_ATTR_VALUES_TLP_INTERFACE rows updated='||SQL% rowcount);
3618: END IF;
3619:
3620: l_progress := '020';
3621: INSERT

Line 4641: FROM PO_ATTR_VALUES_TLP_INTERFACE

4637: TL_TEXT_CAT_ATTRIBUTE7,
4638: TL_TEXT_CAT_ATTRIBUTE8,
4639: TL_TEXT_CAT_ATTRIBUTE9,
4640: 'AUTOCREATE_BACKEND_FOR_SOURCING'
4641: FROM PO_ATTR_VALUES_TLP_INTERFACE
4642: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;
4643:
4644: --
4645: IF g_debug_stmt THEN