DBA Data[Home] [Help]

APPS.WMS_BULK_PICK dependencies on WSH_DELIVERY_DETAILS

Line 1255: wsh_delivery_details wdd,wsh_delivery_assignments_v wda

1251: , mmtt.transaction_quantity
1252: , mmtt.primary_quantity
1253: , mmtt.secondary_transaction_quantity --bug 8197506
1254: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,
1255: wsh_delivery_details wdd,wsh_delivery_assignments_v wda
1256: WHERE mmtt.parent_line_id = p_temp_id
1257: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line
1258: AND mmtt.organization_id = p_org_id
1259: AND mol.line_id = mmtt.move_order_line_id

Line 1272: wsh_delivery_details wdd,wsh_delivery_assignments_v wda,

1268: , mmtt.transaction_quantity
1269: , mmtt.primary_quantity
1270: , mmtt.secondary_transaction_quantity --bug 8197506
1271: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,
1272: wsh_delivery_details wdd,wsh_delivery_assignments_v wda,
1273: oe_order_lines_all ol,mtl_txn_request_headers moh
1274: WHERE mmtt.parent_line_id = p_temp_id
1275: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line
1276: AND mmtt.organization_id = p_org_id