DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_PARAMETERS

Line 1070: AND mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')

1066: WHERE mtrl.header_id = mtrh.header_id
1067: AND mtrl.organization_id = mtrh.organization_id
1068: AND mtrl.organization_id = L_ORG_ID
1069: AND mtrl.inventory_item_id = L_item_id
1070: AND mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')
1071: AND MTRH.move_order_type = 2
1072: and mtrl.line_status in (3,7) -- only approved and pre-approved
1073: and mtrl.transaction_type_id = 64
1074: and mtrl.transaction_source_type_id = 4

Line 7141: and mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')

7137: FROM mtl_txn_request_lines mtrl,
7138: Mtl_txn_request_headers mtrh
7139: WHERE mtrl.header_id = mtrh.header_id
7140: And mtrl.organization_id = mtrh.organization_id
7141: and mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')
7142: And MTRH.move_order_type = 2
7143: and mtrl.line_status in (3,7) -- only approved and pre-approved
7144: and (mtrl.quantity - (Nvl(mtrl.quantity_detailed,0) + Nvl(mtrl.quantity_delivered,0))) > 0
7145: and mtrh.transaction_type_id = 64