APPS.JMF_SHIKYU_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 738: mtl_system_items_b msib,

734: FROM dual
735: WHERE exists
736: (SELECT 'X'
737: FROM oe_order_lines_all oola,
738: mtl_system_items_b msib,
739: jmf_shikyu_replenishments jsr
740: WHERE oola.inventory_item_id = msib.inventory_item_id
741: AND msib.organization_id = jsr.oem_organization_id
742: AND msib.subcontracting_component in (1, 2)

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

832: PO_ASL_ATTRIBUTES.CONSIGNED_FROM_SUPPLIER_FLAG%TYPE := NULL;
833: l_enable_vmi_flag
834: PO_ASL_ATTRIBUTES.ENABLE_VMI_FLAG%TYPE := NULL;
835: l_ship_to_org_item_osa_flag
836: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;
837: l_tp_org_item_osa_flag
838: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;
839:
840: BEGIN

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

834: PO_ASL_ATTRIBUTES.ENABLE_VMI_FLAG%TYPE := NULL;
835: l_ship_to_org_item_osa_flag
836: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;
837: l_tp_org_item_osa_flag
838: MTL_SYSTEM_ITEMS_B.OUTSOURCED_ASSEMBLY%TYPE := NULL;
839:
840: BEGIN
841:
842: IF g_fnd_debug = 'Y' AND

Line 875: FROM mtl_system_items_b msib

871: -- Get the outsourced_assembly flag of the item having the passed
872: -- in item id and ship to organization id
873: SELECT msib.outsourced_assembly
874: INTO l_ship_to_org_item_osa_flag
875: FROM mtl_system_items_b msib
876: WHERE msib.inventory_item_id = p_inventory_item_id
877: AND msib.organization_id = p_ship_to_organization_id;
878:
879: /* Validation of the item level OSA flag in the Ship to Organization */

Line 896: MTL_SYSTEM_ITEMS_B msib

892: msib.outsourced_assembly
893: INTO l_tp_organization_id,
894: l_tp_org_item_osa_flag
895: FROM HR_ORGANIZATION_INFORMATION hoi,
896: MTL_SYSTEM_ITEMS_B msib
897: WHERE hoi.org_information_context = 'Customer/Supplier Association'
898: AND hoi.org_information3 = p_vendor_id
899: AND hoi.org_information4 = p_vendor_site_id
900: AND msib.organization_id = hoi.organization_id

Line 1055: FROM mtl_system_items_b

1051: -- End API initialization
1052:
1053: SELECT outsourced_assembly, subcontracting_component
1054: INTO X_outsourced_assembly, x_subcontracting_component
1055: FROM mtl_system_items_b
1056: WHERE organization_id = p_organization_id
1057: AND inventory_item_id = p_item_id;
1058:
1059: EXCEPTION