DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on MTL_ITEM_LOCATIONS_KFV

Line 7737: mtl_item_locations_kfv loc

7733: AND r2.resource_type = 1
7734: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7735: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
7736: , -- inlined wms_person_resource_utt_v, bug 2648133
7737: mtl_item_locations_kfv loc
7738: , --changed to kfv bug#2742611
7739: mtl_secondary_inventories sub
7740: , mtl_txn_request_lines mol
7741: , mtl_txn_request_headers moh

Line 7898: mtl_item_locations_kfv loc

7894: AND r2.resource_type = 1
7895: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7896: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
7897: , -- inlined wms_person_resource_utt_v, bug 2648133
7898: mtl_item_locations_kfv loc
7899: , --changed to kfv bug#2742611
7900: mtl_secondary_inventories sub
7901: , mtl_txn_request_lines mol
7902: , mtl_txn_request_headers moh

Line 8058: mtl_item_locations_kfv loc

8054: AND r2.resource_type = 1
8055: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8056: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8057: , -- inlined wms_person_resource_utt_v, bug 2648133
8058: mtl_item_locations_kfv loc
8059: , --changed to kfv bug#2742611
8060: mtl_secondary_inventories sub
8061: , mtl_txn_request_lines mol
8062: , mtl_txn_request_headers moh

Line 8218: mtl_item_locations_kfv loc

8214: AND r2.resource_type = 1
8215: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8216: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8217: , -- inlined wms_person_resource_utt_v, bug 2648133
8218: mtl_item_locations_kfv loc
8219: , --changed to kfv bug#2742611
8220: mtl_secondary_inventories sub
8221: , mtl_txn_request_lines mol
8222: , mtl_txn_request_headers moh

Line 8347: , mtl_item_locations_kfv loc

8343: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8344: WHERE bsor.resource_id = bre.resource_id
8345: AND br.resource_type = 1
8346: AND bsor.resource_id = br.resource_id) e
8347: , mtl_item_locations_kfv loc
8348: , --changed to kfv bug#2742611
8349: mtl_secondary_inventories sub
8350: , mtl_txn_request_lines mol
8351: , mtl_txn_request_headers moh

Line 8454: mtl_item_locations_kfv loc

8450: AND r2.resource_type = 1
8451: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8452: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8453: , -- inlined wms_person_resource_utt_v, bug 2648133
8454: mtl_item_locations_kfv loc
8455: , --changed to kfv bug#2742611
8456: mtl_secondary_inventories sub
8457: , mtl_txn_request_lines mol
8458: , mtl_txn_request_headers moh

Line 8589: , mtl_item_locations_kfv loc

8585: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8586: WHERE bsor.resource_id = bre.resource_id
8587: AND br.resource_type = 1
8588: AND bsor.resource_id = br.resource_id) e
8589: , mtl_item_locations_kfv loc
8590: , --changed to kfv bug#2742611
8591: mtl_secondary_inventories sub
8592: , mtl_txn_request_lines mol
8593: , mtl_txn_request_headers moh

Line 8686: mtl_item_locations_kfv loc

8682: AND r2.resource_type = 1
8683: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8684: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8685: , -- inlined wms_person_resource_utt_v, bug 2648133
8686: mtl_item_locations_kfv loc
8687: , --changed to kfv bug#2742611
8688: mtl_secondary_inventories sub
8689: , mtl_txn_request_lines mol
8690: , mtl_txn_request_headers moh

Line 8819: , mtl_item_locations_kfv loc

8815: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8816: WHERE bsor.resource_id = bre.resource_id
8817: AND br.resource_type = 1
8818: AND bsor.resource_id = br.resource_id) e
8819: , mtl_item_locations_kfv loc
8820: , --changed to kfv bug#2742611
8821: mtl_secondary_inventories sub
8822: , mtl_txn_request_lines mol
8823: , mtl_txn_request_headers moh

Line 8926: mtl_item_locations_kfv loc

8922: AND r2.resource_type = 1
8923: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8924: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8925: , -- inlined wms_person_resource_utt_v, bug 2648133
8926: mtl_item_locations_kfv loc
8927: , --changed to kfv bug#2742611
8928: mtl_secondary_inventories sub
8929: , mtl_txn_request_lines mol
8930: , mtl_txn_request_headers moh

Line 9051: , mtl_item_locations_kfv loc

9047: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9048: WHERE bsor.resource_id = bre.resource_id
9049: AND br.resource_type = 1
9050: AND bsor.resource_id = br.resource_id) e
9051: , mtl_item_locations_kfv loc
9052: , --changed to kfv bug#2742611
9053: mtl_secondary_inventories sub
9054: , mtl_txn_request_lines mol
9055: , mtl_txn_request_headers moh

Line 9150: mtl_item_locations_kfv loc

9146: AND r2.resource_type = 1
9147: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9148: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9149: , -- inlined wms_person_resource_utt_v, bug 2648133
9150: mtl_item_locations_kfv loc
9151: , --changed to kfv bug#2742611
9152: mtl_secondary_inventories sub
9153: , mtl_txn_request_lines mol
9154: , mtl_txn_request_headers moh

Line 9283: , mtl_item_locations_kfv loc

9279: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9280: WHERE bsor.resource_id = bre.resource_id
9281: AND br.resource_type = 1
9282: AND bsor.resource_id = br.resource_id) e
9283: , mtl_item_locations_kfv loc
9284: , --changed to kfv bug#2742611
9285: mtl_secondary_inventories sub
9286: , mtl_txn_request_lines mol
9287: , mtl_txn_request_headers moh

Line 9388: mtl_item_locations_kfv loc

9384: AND r2.resource_type = 1
9385: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9386: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9387: , -- inlined wms_person_resource_utt_v, bug 2648133
9388: mtl_item_locations_kfv loc
9389: , --changed to kfv bug#2742611
9390: mtl_secondary_inventories sub
9391: , mtl_txn_request_lines mol
9392: , mtl_txn_request_headers moh

Line 9520: , mtl_item_locations_kfv loc

9516: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9517: WHERE bsor.resource_id = bre.resource_id
9518: AND br.resource_type = 1
9519: AND bsor.resource_id = br.resource_id) e
9520: , mtl_item_locations_kfv loc
9521: , --changed to kfv bug#2742611
9522: mtl_secondary_inventories sub
9523: , mtl_txn_request_lines mol
9524: , mtl_txn_request_headers moh

Line 9618: mtl_item_locations_kfv loc

9614: AND r2.resource_type = 1
9615: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9616: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9617: , -- inlined wms_person_resource_utt_v, bug 2648133
9618: mtl_item_locations_kfv loc
9619: , --changed to kfv bug#2742611
9620: mtl_secondary_inventories sub
9621: , mtl_txn_request_lines mol
9622: , mtl_txn_request_headers moh

Line 9747: , mtl_item_locations_kfv loc

9743: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9744: WHERE bsor.resource_id = bre.resource_id
9745: AND br.resource_type = 1
9746: AND bsor.resource_id = br.resource_id) e
9747: , mtl_item_locations_kfv loc
9748: , --changed to kfv bug#2742611
9749: mtl_secondary_inventories sub
9750: , mtl_txn_request_lines mol
9751: , mtl_txn_request_headers moh

Line 9852: mtl_item_locations_kfv loc

9848: AND r2.resource_type = 1
9849: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9850: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9851: , -- inlined wms_person_resource_utt_v, bug 2648133
9852: mtl_item_locations_kfv loc
9853: , --changed to kfv bug#2742611
9854: mtl_secondary_inventories sub
9855: , mtl_txn_request_lines mol
9856: , mtl_txn_request_headers moh

Line 9976: , mtl_item_locations_kfv loc

9972: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9973: WHERE bsor.resource_id = bre.resource_id
9974: AND br.resource_type = 1
9975: AND bsor.resource_id = br.resource_id) e
9976: , mtl_item_locations_kfv loc
9977: , --changed to kfv bug#2742611
9978: mtl_secondary_inventories sub
9979: , mtl_txn_request_lines mol
9980: , mtl_txn_request_headers moh

Line 10074: mtl_item_locations_kfv loc

10070: AND r2.resource_type = 1
10071: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
10072: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
10073: , -- inlined wms_person_resource_utt_v, bug 2648133
10074: mtl_item_locations_kfv loc
10075: , --changed to kfv bug#2742611
10076: mtl_secondary_inventories sub
10077: , mtl_txn_request_lines mol
10078: , mtl_txn_request_headers moh