APPS.WMS_TASK_DISPATCH_GEN dependencies on BOM_RESOURCE_EQUIPMENTS

Line 135: FROM bom_resource_equipments

131: l_per_res_id := 1113;
132: l_mac_res_id := 1001;
133:
134: /* SELECT resource_id INTO l_mac_res_id
135: FROM bom_resource_equipments
136: WHERE organization_id=l_org_id
137: AND inventory_item_id=l_eqp_id;
138:
139:

Line 538: --FROM bom_resource_equipments

534: END IF;
535:
536: --IF l_eqp_id IS NOT NULL THEN
537: --SELECT resource_id INTO l_mac_res_id
538: --FROM bom_resource_equipments
539: --WHERE organization_id=l_org_id
540: --AND inventory_item_id=l_eqp_id;
541: --END IF;
542:

Line 748: FROM bom_resource_equipments

744: -- bug fix 1772907, lezhang
745:
746: SELECT resource_id
747: INTO l_mac_res_id
748: FROM bom_resource_equipments
749: WHERE inventory_item_id = l_eqp_id
750: AND ROWNUM < 2;
751: --select breqp.resource_id equip_type_id
752: --INTO l_mac_res_id

Line 1315: FROM bom_resource_equipments

1311:
1312: IF l_eqp_id IS NOT NULL THEN
1313: SELECT resource_id
1314: INTO l_mac_res_id
1315: FROM bom_resource_equipments
1316: WHERE inventory_item_id = l_eqp_id
1317: AND ROWNUM < 2;
1318: END IF;
1319:

Line 12612: FROM bom_resource_equipments

12608: -- bug fix 1772907, lezhang
12609:
12610: SELECT resource_id
12611: INTO l_mac_res_id
12612: FROM bom_resource_equipments
12613: WHERE inventory_item_id = l_eqp_id
12614: AND ROWNUM < 2;
12615: /*
12616: select breqp.resource_id equip_type_id

Line 12969: FROM bom_resource_equipments

12965: -- bug fix 1772907, lezhang
12966:
12967: SELECT resource_id
12968: INTO l_mac_res_id
12969: FROM bom_resource_equipments
12970: WHERE inventory_item_id = l_eqp_id
12971: AND ROWNUM < 2;
12972: /*
12973: select breqp.resource_id equip_type_id