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 5147: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table

5143:
5144: 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;
5145:
5146: l_progress:='820';
5147: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table
5148: --SQL Why : To facilitate bulk update of attributes, later in the flow
5149: --SQL Join: interface_header_id, interface_line_id
5150: FORALL i IN INDICES OF l_po_line_id_tbl
5151: UPDATE PO_ATTR_VALUES_TLP_INTERFACE

Line 5151: UPDATE PO_ATTR_VALUES_TLP_INTERFACE

5147: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table
5148: --SQL Why : To facilitate bulk update of attributes, later in the flow
5149: --SQL Join: interface_header_id, interface_line_id
5150: FORALL i IN INDICES OF l_po_line_id_tbl
5151: UPDATE PO_ATTR_VALUES_TLP_INTERFACE
5152: SET po_line_id = l_po_line_id_tbl(i),
5153: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5154: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5155: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)

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

5152: SET po_line_id = l_po_line_id_tbl(i),
5153: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5154: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5155: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5156: WHERE po_attr_values_tlp_interface.interface_header_id = l_interface_header_id_tbl(i)
5157: AND po_attr_values_tlp_interface.interface_line_id = l_interface_line_id_tbl(i);
5158:
5159: 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;
5160: END IF;

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

5153: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5154: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5155: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5156: WHERE po_attr_values_tlp_interface.interface_header_id = l_interface_header_id_tbl(i)
5157: AND po_attr_values_tlp_interface.interface_line_id = l_interface_line_id_tbl(i);
5158:
5159: 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;
5160: END IF;
5161: --

Line 5159: 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;

5155: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5156: WHERE po_attr_values_tlp_interface.interface_header_id = l_interface_header_id_tbl(i)
5157: AND po_attr_values_tlp_interface.interface_line_id = l_interface_line_id_tbl(i);
5158:
5159: 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;
5160: END IF;
5161: --
5162:
5163: IF g_debug_stmt THEN PO_DEBUG.debug_end(p_log_head => g_log_head||l_api_name); END IF;