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 12864: FROM bom_resource_equipments

12860: -- bug fix 1772907, lezhang
12861:
12862: SELECT resource_id
12863: INTO l_mac_res_id
12864: FROM bom_resource_equipments
12865: WHERE inventory_item_id = l_eqp_id
12866: AND ROWNUM < 2;
12867: /*
12868: select breqp.resource_id equip_type_id

Line 13221: FROM bom_resource_equipments

13217: -- bug fix 1772907, lezhang
13218:
13219: SELECT resource_id
13220: INTO l_mac_res_id
13221: FROM bom_resource_equipments
13222: WHERE inventory_item_id = l_eqp_id
13223: AND ROWNUM < 2;
13224: /*
13225: select breqp.resource_id equip_type_id