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_DOCUMENT_UPDATE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1163: mtl_system_items_b MSI,

1159: p_chg.line_changes.c_preferred_grade(i) --INVCONV
1160: FROM po_lines POL,
1161: po_line_types PLT,
1162: po_headers_all POHA,
1163: mtl_system_items_b MSI,
1164: financials_system_parameters FSP
1165: WHERE POL.po_line_id = p_chg.line_changes.po_line_id(i)
1166: AND PLT.line_type_id = POL.line_type_id -- JOIN
1167: AND POHA.po_header_id(+) = POL.from_header_id -- JOIN

Line 1319: mtl_system_items_b MSI,

1315: --p_chg.shipment_changes.c_payment_type(i)
1316: FROM po_line_locations PLL,
1317: po_lines POL,
1318: po_line_types PLT,
1319: mtl_system_items_b MSI,
1320: financials_system_parameters FSP
1321: WHERE PLL.line_location_id =
1322: NVL( p_chg.shipment_changes.parent_line_location_id(i), -- split shipment
1323: p_chg.shipment_changes.po_line_location_id(i) ) -- existing shipment

Line 1697: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/

1693: l_progress VARCHAR2(3) := '000';
1694:
1695: l_shipment_count NUMBER;
1696: l_return_status VARCHAR2(1);
1697: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/
1698: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */
1699: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */
1700: BEGIN
1701: IF (g_fnd_debug = 'Y') THEN

Line 1698: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */

1694:
1695: l_shipment_count NUMBER;
1696: l_return_status VARCHAR2(1);
1697: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/
1698: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */
1699: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */
1700: BEGIN
1701: IF (g_fnd_debug = 'Y') THEN
1702: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1699: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */

1695: l_shipment_count NUMBER;
1696: l_return_status VARCHAR2(1);
1697: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE; /* INVCONV sschinch 09.08.04*/
1698: l_dual_uom_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE; /* INVCONV sschinch 11.11.04 */
1699: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE; /* INVCONV */
1700: BEGIN
1701: IF (g_fnd_debug = 'Y') THEN
1702: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1703: FND_LOG.string( log_level => FND_LOG.LEVEL_PROCEDURE,

Line 1822: FROM mtl_system_items_b mtl,

1818: p_chg.shipment_changes.get_count = 0) THEN
1819:
1820: SELECT NVL(mtl.grade_control_flag,'N')
1821: INTO l_grade_control_flag
1822: FROM mtl_system_items_b mtl,
1823: financials_system_parameters fsp
1824: WHERE mtl.inventory_item_id = p_chg.line_changes.c_item_id(i)
1825: AND mtl.organization_id = fsp.inventory_organization_id;
1826:

Line 1846: FROM mtl_system_items_b msi,

1842:
1843: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1844: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1845: INTO l_dual_uom_ind,l_secondary_default_ind
1846: FROM mtl_system_items_b msi,
1847: financials_system_parameters fsp
1848: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1849: AND msi.organization_id = fsp.inventory_organization_id;
1850: ELSE

Line 1886: FROM mtl_system_items_b msi,

1882:
1883: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1884: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1885: INTO l_dual_uom_ind,l_secondary_default_ind
1886: FROM mtl_system_items_b msi,
1887: financials_system_parameters fsp
1888: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1889: AND msi.organization_id = fsp.inventory_organization_id;
1890: ELSE

Line 1964: FROM mtl_system_items

1960: IF ( p_chg.shipment_changes.preferred_grade(i) IS NOT NULL)
1961: AND (p_chg.shipment_changes.c_item_id(i) IS NOT NULL) THEN
1962:
1963: SELECT NVL(grade_control_flag,'N') INTO l_grade_control_flag
1964: FROM mtl_system_items
1965: WHERE inventory_item_id = p_chg.shipment_changes.c_item_id(i)
1966: AND organization_id = p_chg.shipment_changes.c_ship_to_organization_id(i) ;
1967:
1968: IF l_grade_control_flag = 'N' THEN

Line 3033: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;

3029:
3030:
3031: l_return_status VARCHAR2(1);
3032: /* INVCONV sschinch 09/07/04 */
3033: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
3034: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE ; --INVCONV sschinch
3035: l_secondary_qty PO_LINE_LOCATIONS.quantity%TYPE;
3036: l_fsp_org_id NUMBER;
3037: x_count NUMBER;

Line 3034: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE ; --INVCONV sschinch

3030:
3031: l_return_status VARCHAR2(1);
3032: /* INVCONV sschinch 09/07/04 */
3033: l_dual_um_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE;
3034: l_secondary_default_ind MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND%TYPE ; --INVCONV sschinch
3035: l_secondary_qty PO_LINE_LOCATIONS.quantity%TYPE;
3036: l_fsp_org_id NUMBER;
3037: x_count NUMBER;
3038: x_data VARCHAR2(100);

Line 3041: l_item_id MTL_SYSTEM_ITEMS_B.inventory_item_id%TYPE;

3037: x_count NUMBER;
3038: x_data VARCHAR2(100);
3039: l_derived_sec_qty PO_LINE_LOCATIONS.quantity%TYPE;
3040: l_document_uom PO_LINES.secondary_unit_of_measure%TYPE;
3041: l_item_id MTL_SYSTEM_ITEMS_B.inventory_item_id%TYPE;
3042: l_document_sec_uom PO_LINES.secondary_unit_of_measure%TYPE;
3043: l_new_secondary_qty PO_LINE_LOCATIONS.quantity%TYPE;
3044:
3045: l_new_amt NUMBER;

Line 3473: FROM mtl_system_items_b msi

3469:
3470: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3471: SELECT msi.tracking_quantity_ind,secondary_default_ind,secondary_uom_code
3472: INTO l_dual_um_ind,l_secondary_default_ind,l_new_sec_uom
3473: FROM mtl_system_items_b msi
3474: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3475: AND msi.organization_id = l_fsp_org_id;
3476: ELSE
3477: l_dual_um_ind := 'P';

Line 3556: FROM mtl_system_items_b msi

3552:
3553: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3554: SELECT msi.tracking_quantity_ind,secondary_default_ind
3555: INTO l_dual_um_ind,l_secondary_default_ind
3556: FROM mtl_system_items_b msi
3557: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3558: AND msi.organization_id = l_fsp_org_id;
3559: ELSE
3560: l_dual_um_ind := 'P';

Line 3642: FROM mtl_system_items_b msi

3638:
3639: IF p_chg.shipment_changes.c_item_id(i) IS NOT NULL THEN
3640: SELECT msi.tracking_quantity_ind,secondary_default_ind
3641: INTO l_dual_um_ind,l_secondary_default_ind
3642: FROM mtl_system_items_b msi
3643: WHERE msi.inventory_item_id = p_chg.shipment_changes.c_item_id(i)
3644: AND msi.organization_id = l_fsp_org_id;
3645: ELSE
3646: l_secondary_default_ind := NULL;

Line 3854: l_item_number MTL_SYSTEM_ITEMS.segment1%TYPE;

3850: l_request_uom PO_LINES.unit_meas_lookup_code%TYPE;
3851: l_cur_uom PO_LINES.unit_meas_lookup_code%TYPE;
3852: l_request_uom2 PO_LINES.secondary_unit_of_measure%TYPE;
3853: l_cur_uom2 PO_LINES.secondary_unit_of_measure%TYPE;
3854: l_item_number MTL_SYSTEM_ITEMS.segment1%TYPE;
3855: l_qty2 PO_LINES.secondary_quantity%TYPE;
3856: l_opm_validate_ind VARCHAR2(1);
3857:
3858: l_last_msg_list_index NUMBER;