APPS.PO_DOCUMENT_UPDATE_PVT dependencies on MTL_SYSTEM_ITEMS_B

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 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 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;