APPS.JMF_SHIKYU_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 756: mtl_system_items_b msib,

752: FROM dual
753: WHERE exists
754: (SELECT 'X'
755: FROM oe_order_lines_all oola,
756: mtl_system_items_b msib,
757: jmf_shikyu_replenishments jsr
758: WHERE oola.inventory_item_id = msib.inventory_item_id
759: AND msib.organization_id = jsr.oem_organization_id
760: AND msib.subcontracting_component in (1, 2)

Line 854: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;

850: PO_ASL_ATTRIBUTES.CONSIGNED_FROM_SUPPLIER_FLAG%TYPE := NULL;
851: l_enable_vmi_flag
852: PO_ASL_ATTRIBUTES.ENABLE_VMI_FLAG%TYPE := NULL;
853: l_ship_to_org_item_osa_flag
854: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;
855: l_tp_org_item_osa_flag
856: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;
857:
858: BEGIN

Line 856: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;

852: PO_ASL_ATTRIBUTES.ENABLE_VMI_FLAG%TYPE := NULL;
853: l_ship_to_org_item_osa_flag
854: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;
855: l_tp_org_item_osa_flag
856: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;
857:
858: BEGIN
859:
860: IF g_fnd_debug = 'Y' AND

Line 893: FROM mtl_system_items_b msib

889: -- Get the outsourced_assembly flag of the item having the passed
890: -- in item id and ship to organization id
891: SELECT msib.outsourced_assembly
892: INTO l_ship_to_org_item_osa_flag
893: FROM mtl_system_items_b msib
894: WHERE msib.inventory_item_id = p_inventory_item_id
895: AND msib.organization_id = p_ship_to_organization_id;
896:
897: /* Validation of the item level OSA flag in the Ship to Organization */

Line 914: MTL_SYSTEM_ITEMS_B msib

910: msib.outsourced_assembly
911: INTO l_tp_organization_id,
912: l_tp_org_item_osa_flag
913: FROM HR_ORGANIZATION_INFORMATION hoi,
914: MTL_SYSTEM_ITEMS_B msib
915: WHERE hoi.org_information_context = 'Customer/Supplier Association'
916: AND hoi.org_information3 = p_vendor_id
917: AND hoi.org_information4 = p_vendor_site_id
918: AND msib.organization_id = hoi.organization_id

Line 1073: FROM mtl_system_items_b

1069: -- End API initialization
1070:
1071: SELECT outsourced_assembly, subcontracting_component
1072: INTO X_outsourced_assembly, x_subcontracting_component
1073: FROM mtl_system_items_b
1074: WHERE organization_id = p_organization_id
1075: AND inventory_item_id = p_item_id;
1076:
1077: EXCEPTION