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

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

5603:
5604: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL%rowcount);END IF;
5605:
5606: l_progress:='820';
5607: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table
5608: --SQL Why : To facilitate bulk update of attributes, later in the flow
5609: --SQL Join: interface_header_id, interface_line_id
5610: FORALL i IN INDICES OF l_po_line_id_tbl
5611: UPDATE PO_ATTR_VALUES_TLP_INTERFACE

Line 5611: UPDATE PO_ATTR_VALUES_TLP_INTERFACE

5607: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table
5608: --SQL Why : To facilitate bulk update of attributes, later in the flow
5609: --SQL Join: interface_header_id, interface_line_id
5610: FORALL i IN INDICES OF l_po_line_id_tbl
5611: UPDATE PO_ATTR_VALUES_TLP_INTERFACE
5612: SET po_line_id = l_po_line_id_tbl(i),
5613: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5614: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5615: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)

Line 5616: WHERE po_attr_values_tlp_interface.interface_header_id = l_interface_header_id_tbl(i)

5612: SET po_line_id = l_po_line_id_tbl(i),
5613: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5614: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5615: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5616: WHERE po_attr_values_tlp_interface.interface_header_id = l_interface_header_id_tbl(i)
5617: AND po_attr_values_tlp_interface.interface_line_id = l_interface_line_id_tbl(i);
5618:
5619: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Number of PO_ATTR_VALUES_TLP_INTERFACE rows updated='||SQL%rowcount);END IF;
5620: END IF;

Line 5617: AND po_attr_values_tlp_interface.interface_line_id = l_interface_line_id_tbl(i);

5613: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5614: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5615: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5616: WHERE po_attr_values_tlp_interface.interface_header_id = l_interface_header_id_tbl(i)
5617: AND po_attr_values_tlp_interface.interface_line_id = l_interface_line_id_tbl(i);
5618:
5619: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Number of PO_ATTR_VALUES_TLP_INTERFACE rows updated='||SQL%rowcount);END IF;
5620: END IF;
5621: --

Line 5619: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Number of PO_ATTR_VALUES_TLP_INTERFACE rows updated='||SQL%rowcount);END IF;

5615: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5616: WHERE po_attr_values_tlp_interface.interface_header_id = l_interface_header_id_tbl(i)
5617: AND po_attr_values_tlp_interface.interface_line_id = l_interface_line_id_tbl(i);
5618:
5619: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Number of PO_ATTR_VALUES_TLP_INTERFACE rows updated='||SQL%rowcount);END IF;
5620: END IF;
5621: --
5622:
5623: IF g_debug_stmt THEN PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name); END IF;