APPS.GMD_SPEC_VRS_GRP dependencies on MTL_SYSTEM_ITEMS_B

Line 686: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

682: l_spec GMD_SPECIFICATIONS%ROWTYPE;
683: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
684: l_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE;
685: l_inv_vr_tmp GMD_INVENTORY_SPEC_VRS%ROWTYPE;
686: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
687: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
688: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
689: l_inventory_item_id NUMBER;
690: l_organization_id NUMBER;

Line 801: FROM mtl_system_items_b

797: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;
798: SELECT owner_organization_id INTO l_organization_id FROM
799: gmd_specifications WHERE spec_id = p_inv_vr.spec_id;
800: SELECT * INTO l_item_mst
801: FROM mtl_system_items_b
802: WHERE inventory_item_id = l_inventory_item_id
803: AND organization_id = l_organization_id;
804: EXCEPTION
805: WHEN OTHERS THEN

Line 1315: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

1311: l_spec GMD_SPECIFICATIONS%ROWTYPE;
1312: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
1313: l_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE;
1314: l_wip_vr_tmp GMD_WIP_SPEC_VRS%ROWTYPE;
1315: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
1316: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
1317: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
1318: l_inventory_item_id NUMBER;
1319: l_organization_id NUMBER;

Line 1429: FROM mtl_system_items_b

1425: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;
1426: SELECT owner_organization_id INTO l_organization_id FROM
1427: gmd_specifications WHERE spec_id = p_wip_vr.spec_id;
1428: SELECT * INTO l_item_mst
1429: FROM mtl_system_items_b
1430: WHERE inventory_item_id = l_inventory_item_id
1431: AND organization_id = l_organization_id;
1432: EXCEPTION
1433: WHEN OTHERS THEN

Line 2534: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

2530: l_return_status VARCHAR2(1);
2531:
2532: l_spec GMD_SPECIFICATIONS%ROWTYPE;
2533: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
2534: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
2535: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
2536: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
2537: l_inventory_item_id NUMBER;
2538: l_organization_id NUMBER;

Line 2622: FROM mtl_system_items_b

2618: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;
2619: SELECT owner_organization_id INTO l_organization_id FROM
2620: gmd_specifications WHERE spec_id = p_cust_vr.spec_id;
2621: SELECT * INTO l_item_mst
2622: FROM mtl_system_items_b
2623: WHERE inventory_item_id = l_inventory_item_id
2624: AND organization_id = l_organization_id;
2625: EXCEPTION
2626: WHEN OTHERS THEN

Line 3184: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;

3180: l_return_status VARCHAR2(1);
3181:
3182: l_spec GMD_SPECIFICATIONS%ROWTYPE;
3183: l_spec_out GMD_SPECIFICATIONS%ROWTYPE;
3184: l_item_mst MTL_SYSTEM_ITEMS_B%ROWTYPE;
3185: l_sampling_plan GMD_SAMPLING_PLANS%ROWTYPE;
3186: l_sampling_plan_out GMD_SAMPLING_PLANS%ROWTYPE;
3187: l_inventory_item_id NUMBER;
3188: l_organization_id NUMBER;

Line 3288: FROM mtl_system_items_b

3284: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;
3285: SELECT owner_organization_id INTO l_organization_id FROM
3286: gmd_specifications WHERE spec_id = p_supp_vr.spec_id;
3287: SELECT * INTO l_item_mst
3288: FROM mtl_system_items_b
3289: WHERE inventory_item_id = l_inventory_item_id
3290: AND organization_id = l_organization_id;
3291: EXCEPTION
3292: WHEN OTHERS THEN

Line 3388: FROM mtl_system_items_b

3384: IS
3385:
3386: CURSOR c_item_controls IS
3387: SELECT lot_control_code
3388: FROM mtl_system_items_b
3389: WHERE inventory_item_id = p_spec.inventory_item_id
3390: AND organization_id = p_spec.owner_organization_id;
3391:
3392: CURSOR c_supplier IS