APPS.MSC_X_HZ_UPDATE dependencies on MSC_SYSTEM_ITEMS

Line 545: FROM msc_system_items msi,

541: IF (v_pub_id = 1) THEN
542: BEGIN
543: SELECT msi.uom_code
544: INTO l_primary_uom
545: FROM msc_system_items msi,
546: msc_trading_partners part,
547: msc_trading_partner_maps map
548: WHERE msi.inventory_item_id = v_i_item_id(cnt)
549: AND msi.organization_id = part.sr_tp_id

Line 576: FROM msc_system_items msi,

572: --If the ASL is not present, derive the primary uom from the oem
573: BEGIN
574: SELECT msi.uom_code
575: INTO l_primary_uom
576: FROM msc_system_items msi,
577: msc_trading_partners part,
578: msc_trading_partner_maps map
579: WHERE msi.inventory_item_id = v_i_item_id(cnt)
580: AND msi.organization_id = part.sr_tp_id

Line 627: FROM msc_system_items msi,

623: --If the uom is not available from MIC, derive it from the OEM
624: BEGIN
625: SELECT msi.uom_code
626: INTO l_primary_uom
627: FROM msc_system_items msi,
628: msc_trading_partners part,
629: msc_trading_partner_maps map
630: WHERE msi.inventory_item_id = v_i_item_id(cnt)
631: AND msi.organization_id = part.sr_tp_id

Line 658: FROM msc_system_items msi,

654: IF (v_i_cust_id(cnt) = 1) THEN
655: BEGIN
656: SELECT msi.uom_code
657: INTO l_tp_uom
658: FROM msc_system_items msi,
659: msc_trading_partners part,
660: msc_trading_partner_maps map
661: WHERE msi.inventory_item_id = v_i_item_id(cnt)
662: AND msi.organization_id = part.sr_tp_id

Line 705: FROM msc_system_items msi,

701: IF (v_i_sup_id(cnt) = 1) THEN
702: BEGIN
703: SELECT msi.uom_code
704: INTO l_tp_uom
705: FROM msc_system_items msi,
706: msc_trading_partners part,
707: msc_trading_partner_maps map
708: WHERE msi.inventory_item_id = v_i_item_id(cnt)
709: AND msi.organization_id = part.sr_tp_id