APPS.PO_DOCUMENT_UPDATE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1186: mtl_system_items_b MSI,

1182: p_chg.line_changes.c_preferred_grade(i) --INVCONV
1183: FROM po_lines POL,
1184: po_line_types PLT,
1185: po_headers_all POHA,
1186: mtl_system_items_b MSI,
1187: financials_system_parameters FSP
1188: WHERE POL.po_line_id = p_chg.line_changes.po_line_id(i)
1189: AND PLT.line_type_id = POL.line_type_id -- JOIN
1190: AND POHA.po_header_id(+) = POL.from_header_id -- JOIN

Line 1342: mtl_system_items_b MSI,

1338: --p_chg.shipment_changes.c_payment_type(i)
1339: FROM po_line_locations PLL,
1340: po_lines POL,
1341: po_line_types PLT,
1342: mtl_system_items_b MSI,
1343: financials_system_parameters FSP
1344: WHERE PLL.line_location_id =
1345: NVL( p_chg.shipment_changes.parent_line_location_id(i), -- split shipment
1346: p_chg.shipment_changes.po_line_location_id(i) ) -- existing shipment

Line 1845: FROM mtl_system_items_b mtl,

1841: p_chg.shipment_changes.get_count = 0) THEN
1842:
1843: SELECT NVL(mtl.grade_control_flag,'N')
1844: INTO l_grade_control_flag
1845: FROM mtl_system_items_b mtl,
1846: financials_system_parameters fsp
1847: WHERE mtl.inventory_item_id = p_chg.line_changes.c_item_id(i)
1848: AND mtl.organization_id = fsp.inventory_organization_id;
1849:

Line 1869: FROM mtl_system_items_b msi,

1865:
1866: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1867: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1868: INTO l_dual_uom_ind,l_secondary_default_ind
1869: FROM mtl_system_items_b msi,
1870: financials_system_parameters fsp
1871: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1872: AND msi.organization_id = fsp.inventory_organization_id;
1873: ELSE

Line 1909: FROM mtl_system_items_b msi,

1905:
1906: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
1907: SELECT msi.tracking_quantity_ind,msi.secondary_default_ind
1908: INTO l_dual_uom_ind,l_secondary_default_ind
1909: FROM mtl_system_items_b msi,
1910: financials_system_parameters fsp
1911: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
1912: AND msi.organization_id = fsp.inventory_organization_id;
1913: ELSE

Line 3064: l_item_id MTL_SYSTEM_ITEMS_B.inventory_item_id%TYPE;

3060: x_count NUMBER;
3061: x_data VARCHAR2(100);
3062: l_derived_sec_qty PO_LINE_LOCATIONS.quantity%TYPE;
3063: l_document_uom PO_LINES.secondary_unit_of_measure%TYPE;
3064: l_item_id MTL_SYSTEM_ITEMS_B.inventory_item_id%TYPE;
3065: l_document_sec_uom PO_LINES.secondary_unit_of_measure%TYPE;
3066: l_new_secondary_qty PO_LINE_LOCATIONS.quantity%TYPE;
3067:
3068: l_new_amt NUMBER;

Line 3496: FROM mtl_system_items_b msi

3492:
3493: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3494: SELECT msi.tracking_quantity_ind,secondary_default_ind,secondary_uom_code
3495: INTO l_dual_um_ind,l_secondary_default_ind,l_new_sec_uom
3496: FROM mtl_system_items_b msi
3497: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3498: AND msi.organization_id = l_fsp_org_id;
3499: ELSE
3500: l_dual_um_ind := 'P';

Line 3578: FROM mtl_system_items_b msi

3574:
3575: IF p_chg.line_changes.c_item_id(i) IS NOT NULL THEN
3576: SELECT msi.tracking_quantity_ind,secondary_default_ind
3577: INTO l_dual_um_ind,l_secondary_default_ind
3578: FROM mtl_system_items_b msi
3579: WHERE msi.inventory_item_id = p_chg.line_changes.c_item_id(i)
3580: AND msi.organization_id = l_fsp_org_id;
3581: ELSE
3582: l_dual_um_ind := 'P';

Line 3679: FROM mtl_system_items_b msi

3675:
3676: IF p_chg.shipment_changes.c_item_id(i) IS NOT NULL THEN
3677: SELECT msi.tracking_quantity_ind,secondary_default_ind
3678: INTO l_dual_um_ind,l_secondary_default_ind
3679: FROM mtl_system_items_b msi
3680: WHERE msi.inventory_item_id = p_chg.shipment_changes.c_item_id(i)
3681: AND msi.organization_id = l_fsp_org_id;
3682: ELSE
3683: l_secondary_default_ind := NULL;