DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 1984: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,

1980: mtrl.secondary_uom_code AS secondary_uom_code,
1981: mtrl.project_id AS project_id,
1982: mtrl.task_id AS task_id,
1983: mtrl.lpn_id AS lpn_id
1984: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
1985: wms_license_plate_numbers wlpn
1986: WHERE mtrl.header_id = mtrh.header_id
1987: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
1988: AND mtrl.organization_id = l_organization_id

Line 2298: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,

2294: mtrl.secondary_uom_code AS secondary_uom_code,
2295: mtrl.project_id AS project_id,
2296: mtrl.task_id AS task_id,
2297: mtrl.lpn_id AS lpn_id
2298: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
2299: wms_license_plate_numbers wlpn
2300: WHERE mtrl.header_id = mtrh.header_id
2301: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
2302: AND mtrl.organization_id = l_organization_id

Line 6485: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,

6481: p_wip_entity_id NUMBER,
6482: p_operation_seq_num NUMBER,
6483: p_repetitive_schedule_id NUMBER) IS
6484: SELECT mtrl.line_id
6485: FROM mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh,
6486: wms_license_plate_numbers wlpn
6487: WHERE mtrl.header_id = mtrh.header_id
6488: AND mtrh.move_order_type = inv_globals.g_move_order_put_away
6489: AND mtrl.organization_id = l_organization_id