DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_PARAMETERS

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

1049: WHERE mtrl.header_id = mtrh.header_id
1050: AND mtrl.organization_id = mtrh.organization_id
1051: AND mtrl.organization_id = L_ORG_ID
1052: AND mtrl.inventory_item_id = L_item_id
1053: AND mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')
1054: AND MTRH.move_order_type = 2
1055: and mtrl.line_status in (3,7) -- only approved and pre-approved
1056: and mtrl.transaction_type_id = 64
1057: and mtrl.transaction_source_type_id = 4

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

6962: FROM mtl_txn_request_lines mtrl,
6963: Mtl_txn_request_headers mtrh
6964: WHERE mtrl.header_id = mtrh.header_id
6965: And mtrl.organization_id = mtrh.organization_id
6966: and mtrl.organization_id in (select organization_id from mtl_parameters where wms_enabled_flag = 'Y')
6967: And MTRH.move_order_type = 2
6968: and mtrl.line_status in (3,7) -- only approved and pre-approved
6969: and (mtrl.quantity - (Nvl(mtrl.quantity_detailed,0) + Nvl(mtrl.quantity_delivered,0))) > 0
6970: and mtrh.transaction_type_id = 64