APPS.GMD_SPEC_VRS_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 697: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

693: l_spec GMD_SPECIFICATIONS%ROWTYPE;
694: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
695: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
696: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
697: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
698: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
699: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
700: l_inventory_item_id NUMBER;
701: l_organization_id NUMBER;

Line 812: FROM mtl_system_items_b

808: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;
809: SELECT owner_organization_id INTO l_organization_id FROM
810: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;
811: SELECT * INTO l_item_mst
812: FROM mtl_system_items_b
813: WHERE inventory_item_id = l_inventory_item_id
814: AND organization_id = l_organization_id;
815: EXCEPTION
816: WHEN OTHERS THEN

Line 1340: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

1336: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1337: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1338: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1339: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;
1340: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
1341: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1342: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
1343: l_inventory_item_id NUMBER;
1344: l_organization_id NUMBER;

Line 1454: FROM mtl_system_items_b

1450: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;
1451: SELECT owner_organization_id INTO l_organization_id FROM
1452: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;
1453: SELECT * INTO l_item_mst
1454: FROM mtl_system_items_b
1455: WHERE inventory_item_id = l_inventory_item_id
1456: AND organization_id = l_organization_id;
1457: EXCEPTION
1458: WHEN OTHERS THEN

Line 2683: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

2679: l_return_status VARCHAR2(1);
2680:
2681: l_spec GMD_SPECIFICATIONS%ROWTYPE;
2682: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
2683: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
2684: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
2685: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
2686: l_inventory_item_id NUMBER;
2687: l_organization_id NUMBER;

Line 2771: FROM mtl_system_items_b

2767: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;
2768: SELECT owner_organization_id INTO l_organization_id FROM
2769: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;
2770: SELECT * INTO l_item_mst
2771: FROM mtl_system_items_b
2772: WHERE inventory_item_id = l_inventory_item_id
2773: AND organization_id = l_organization_id;
2774: EXCEPTION
2775: WHEN OTHERS THEN

Line 3334: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

3330: l_return_status VARCHAR2(1);
3331:
3332: l_spec GMD_SPECIFICATIONS%ROWTYPE;
3333: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
3334: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
3335: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
3336: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
3337: l_inventory_item_id NUMBER;
3338: l_organization_id NUMBER;

Line 3438: FROM mtl_system_items_b

3434: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;
3435: SELECT owner_organization_id INTO l_organization_id FROM
3436: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;
3437: SELECT * INTO l_item_mst
3438: FROM mtl_system_items_b
3439: WHERE inventory_item_id = l_inventory_item_id
3440: AND organization_id = l_organization_id;
3441: EXCEPTION
3442: WHEN OTHERS THEN

Line 3538: FROM mtl_system_items_b

3534: IS
3535:
3536: CURSOR c_item_controls IS
3537: SELECT lot_control_code
3538: FROM mtl_system_items_b
3539: WHERE inventory_item_id = p_spec.inventory_item_id
3540: AND organization_id = p_spec.owner_organization_id;
3541:
3542: CURSOR c_supplier IS