DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_ENGINE dependencies on MTL_ITEM_LOCATIONS_KFV

Line 7398: mtl_item_locations_kfv loc

7394: AND r2.resource_type = 1
7395: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7396: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
7397: , -- inlined wms_person_resource_utt_v, bug 2648133
7398: mtl_item_locations_kfv loc
7399: , --changed to kfv bug#2742611
7400: mtl_secondary_inventories sub
7401: , mtl_txn_request_lines mol
7402: , mtl_txn_request_headers moh

Line 7559: mtl_item_locations_kfv loc

7555: AND r2.resource_type = 1
7556: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7557: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
7558: , -- inlined wms_person_resource_utt_v, bug 2648133
7559: mtl_item_locations_kfv loc
7560: , --changed to kfv bug#2742611
7561: mtl_secondary_inventories sub
7562: , mtl_txn_request_lines mol
7563: , mtl_txn_request_headers moh

Line 7719: mtl_item_locations_kfv loc

7715: AND r2.resource_type = 1
7716: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7717: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
7718: , -- inlined wms_person_resource_utt_v, bug 2648133
7719: mtl_item_locations_kfv loc
7720: , --changed to kfv bug#2742611
7721: mtl_secondary_inventories sub
7722: , mtl_txn_request_lines mol
7723: , mtl_txn_request_headers moh

Line 7879: mtl_item_locations_kfv loc

7875: AND r2.resource_type = 1
7876: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
7877: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
7878: , -- inlined wms_person_resource_utt_v, bug 2648133
7879: mtl_item_locations_kfv loc
7880: , --changed to kfv bug#2742611
7881: mtl_secondary_inventories sub
7882: , mtl_txn_request_lines mol
7883: , mtl_txn_request_headers moh

Line 8008: , mtl_item_locations_kfv loc

8004: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8005: WHERE bsor.resource_id = bre.resource_id
8006: AND br.resource_type = 1
8007: AND bsor.resource_id = br.resource_id) e
8008: , mtl_item_locations_kfv loc
8009: , --changed to kfv bug#2742611
8010: mtl_secondary_inventories sub
8011: , mtl_txn_request_lines mol
8012: , mtl_txn_request_headers moh

Line 8115: mtl_item_locations_kfv loc

8111: AND r2.resource_type = 1
8112: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8113: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8114: , -- inlined wms_person_resource_utt_v, bug 2648133
8115: mtl_item_locations_kfv loc
8116: , --changed to kfv bug#2742611
8117: mtl_secondary_inventories sub
8118: , mtl_txn_request_lines mol
8119: , mtl_txn_request_headers moh

Line 8250: , mtl_item_locations_kfv loc

8246: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8247: WHERE bsor.resource_id = bre.resource_id
8248: AND br.resource_type = 1
8249: AND bsor.resource_id = br.resource_id) e
8250: , mtl_item_locations_kfv loc
8251: , --changed to kfv bug#2742611
8252: mtl_secondary_inventories sub
8253: , mtl_txn_request_lines mol
8254: , mtl_txn_request_headers moh

Line 8347: mtl_item_locations_kfv loc

8343: AND r2.resource_type = 1
8344: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8345: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8346: , -- inlined wms_person_resource_utt_v, bug 2648133
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 8480: , mtl_item_locations_kfv loc

8476: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8477: WHERE bsor.resource_id = bre.resource_id
8478: AND br.resource_type = 1
8479: AND bsor.resource_id = br.resource_id) e
8480: , mtl_item_locations_kfv loc
8481: , --changed to kfv bug#2742611
8482: mtl_secondary_inventories sub
8483: , mtl_txn_request_lines mol
8484: , mtl_txn_request_headers moh

Line 8587: mtl_item_locations_kfv loc

8583: AND r2.resource_type = 1
8584: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8585: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8586: , -- inlined wms_person_resource_utt_v, bug 2648133
8587: mtl_item_locations_kfv loc
8588: , --changed to kfv bug#2742611
8589: mtl_secondary_inventories sub
8590: , mtl_txn_request_lines mol
8591: , mtl_txn_request_headers moh

Line 8712: , mtl_item_locations_kfv loc

8708: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8709: WHERE bsor.resource_id = bre.resource_id
8710: AND br.resource_type = 1
8711: AND bsor.resource_id = br.resource_id) e
8712: , mtl_item_locations_kfv loc
8713: , --changed to kfv bug#2742611
8714: mtl_secondary_inventories sub
8715: , mtl_txn_request_lines mol
8716: , mtl_txn_request_headers moh

Line 8811: mtl_item_locations_kfv loc

8807: AND r2.resource_type = 1
8808: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
8809: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
8810: , -- inlined wms_person_resource_utt_v, bug 2648133
8811: mtl_item_locations_kfv loc
8812: , --changed to kfv bug#2742611
8813: mtl_secondary_inventories sub
8814: , mtl_txn_request_lines mol
8815: , mtl_txn_request_headers moh

Line 8944: , mtl_item_locations_kfv loc

8940: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
8941: WHERE bsor.resource_id = bre.resource_id
8942: AND br.resource_type = 1
8943: AND bsor.resource_id = br.resource_id) e
8944: , mtl_item_locations_kfv loc
8945: , --changed to kfv bug#2742611
8946: mtl_secondary_inventories sub
8947: , mtl_txn_request_lines mol
8948: , mtl_txn_request_headers moh

Line 9049: mtl_item_locations_kfv loc

9045: AND r2.resource_type = 1
9046: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9047: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9048: , -- inlined wms_person_resource_utt_v, bug 2648133
9049: mtl_item_locations_kfv loc
9050: , --changed to kfv bug#2742611
9051: mtl_secondary_inventories sub
9052: , mtl_txn_request_lines mol
9053: , mtl_txn_request_headers moh

Line 9181: , mtl_item_locations_kfv loc

9177: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9178: WHERE bsor.resource_id = bre.resource_id
9179: AND br.resource_type = 1
9180: AND bsor.resource_id = br.resource_id) e
9181: , mtl_item_locations_kfv loc
9182: , --changed to kfv bug#2742611
9183: mtl_secondary_inventories sub
9184: , mtl_txn_request_lines mol
9185: , mtl_txn_request_headers moh

Line 9279: mtl_item_locations_kfv loc

9275: AND r2.resource_type = 1
9276: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9277: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9278: , -- inlined wms_person_resource_utt_v, bug 2648133
9279: mtl_item_locations_kfv loc
9280: , --changed to kfv bug#2742611
9281: mtl_secondary_inventories sub
9282: , mtl_txn_request_lines mol
9283: , mtl_txn_request_headers moh

Line 9408: , mtl_item_locations_kfv loc

9404: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9405: WHERE bsor.resource_id = bre.resource_id
9406: AND br.resource_type = 1
9407: AND bsor.resource_id = br.resource_id) e
9408: , mtl_item_locations_kfv loc
9409: , --changed to kfv bug#2742611
9410: mtl_secondary_inventories sub
9411: , mtl_txn_request_lines mol
9412: , mtl_txn_request_headers moh

Line 9513: mtl_item_locations_kfv loc

9509: AND r2.resource_type = 1
9510: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9511: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9512: , -- inlined wms_person_resource_utt_v, bug 2648133
9513: mtl_item_locations_kfv loc
9514: , --changed to kfv bug#2742611
9515: mtl_secondary_inventories sub
9516: , mtl_txn_request_lines mol
9517: , mtl_txn_request_headers moh

Line 9637: , mtl_item_locations_kfv loc

9633: FROM bom_std_op_resources bsor, bom_resources br, bom_resource_equipments bre
9634: WHERE bsor.resource_id = bre.resource_id
9635: AND br.resource_type = 1
9636: AND bsor.resource_id = br.resource_id) e
9637: , mtl_item_locations_kfv loc
9638: , --changed to kfv bug#2742611
9639: mtl_secondary_inventories sub
9640: , mtl_txn_request_lines mol
9641: , mtl_txn_request_headers moh

Line 9735: mtl_item_locations_kfv loc

9731: AND r2.resource_type = 1
9732: AND x_utt_res2.resource_id = x_eqp_r.resource_id) utt_eqp
9733: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v
9734: , -- inlined wms_person_resource_utt_v, bug 2648133
9735: mtl_item_locations_kfv loc
9736: , --changed to kfv bug#2742611
9737: mtl_secondary_inventories sub
9738: , mtl_txn_request_lines mol
9739: , mtl_txn_request_headers moh