APPS.FLM_KANBAN_TRANSFER dependencies on MTL_TXN_REQUEST_HEADERS

Line 230: FROM mtl_txn_request_headers mtrh,

226: IS
227: SELECT mtrh.header_id,
228: mtrh.move_order_type,
229: mtrl.line_id
230: FROM mtl_txn_request_headers mtrh,
231: mtl_txn_request_lines mtrl,
232: wsh_delivery_details wdd
233: WHERE mtrh.header_id = mtrl.header_id
234: AND mtrl.line_id = wdd.move_order_line_id

Line 248: l_move_order_header_id mtl_txn_request_headers.header_id%TYPE;

244: l_batch_info_rec WSH_PICKING_BATCHES_PUB.Batch_Info_rec;
245: l_source_staging_subinv NUMBER;
246: l_batch_id NUMBER;
247: l_request_id NUMBER;
248: l_move_order_header_id mtl_txn_request_headers.header_id%TYPE;
249: l_move_order_type mtl_txn_request_headers.move_order_type%TYPE;
250: l_move_order_line_id mtl_txn_request_lines.line_id%TYPE;
251: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
252: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

Line 249: l_move_order_type mtl_txn_request_headers.move_order_type%TYPE;

245: l_source_staging_subinv NUMBER;
246: l_batch_id NUMBER;
247: l_request_id NUMBER;
248: l_move_order_header_id mtl_txn_request_headers.header_id%TYPE;
249: l_move_order_type mtl_txn_request_headers.move_order_type%TYPE;
250: l_move_order_line_id mtl_txn_request_lines.line_id%TYPE;
251: l_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
252: l_trolin_old_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
253: l_trolin_out_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;

Line 772: FROM mtl_txn_request_headers

768: CURSOR c_move_order(p_header_id IN NUMBER)
769: IS
770: SELECT request_number,
771: move_order_type
772: FROM mtl_txn_request_headers
773: WHERE header_id = p_header_id;
774:
775: CURSOR c_line_status(p_line_id IN NUMBER)
776: IS

Line 788: l_request_number mtl_txn_request_headers.request_number%TYPE;

784: FROM mtl_txn_request_lines
785: WHERE header_id = p_header_id
786: AND line_status not in (5, 6);
787:
788: l_request_number mtl_txn_request_headers.request_number%TYPE;
789: l_move_order_type mtl_txn_request_headers.move_order_type%TYPE;
790: l_open_lines c_open_lines%ROWTYPE;
791:
792: l_number_of_rows NUMBER;

Line 789: l_move_order_type mtl_txn_request_headers.move_order_type%TYPE;

785: WHERE header_id = p_header_id
786: AND line_status not in (5, 6);
787:
788: l_request_number mtl_txn_request_headers.request_number%TYPE;
789: l_move_order_type mtl_txn_request_headers.move_order_type%TYPE;
790: l_open_lines c_open_lines%ROWTYPE;
791:
792: l_number_of_rows NUMBER;
793: l_detailed_qty NUMBER;

Line 1151: FROM mtl_txn_request_headers mtrh,

1147: IS
1148: SELECT mtrh.request_number,
1149: mtrh.header_id,
1150: mtrl.line_id
1151: FROM mtl_txn_request_headers mtrh,
1152: mtl_txn_request_lines mtrl,
1153: mtl_kanban_cards mkc,
1154: mtl_kanban_card_activity mkca
1155: WHERE mtrh.header_id = mkca.document_header_id

Line 1499: l_intra_order_num mtl_txn_request_headers.request_number%TYPE;

1495: l_inter_order_id oe_order_headers_all.source_document_id%TYPE;
1496: l_inter_line_id oe_order_lines_all.source_document_line_id%TYPE;
1497: l_header_id oe_order_headers_all.header_id%TYPE;
1498: l_line_id oe_order_lines_all.line_id%TYPE;
1499: l_intra_order_num mtl_txn_request_headers.request_number%TYPE;
1500: l_intra_order_id mtl_txn_request_headers.header_id%TYPE;
1501: l_intra_line_id mtl_txn_request_lines.line_id%TYPE;
1502: l_organization_id mtl_kanban_cards.organization_id%TYPE;
1503: l_source_type mtl_kanban_cards.source_type%TYPE;

Line 1500: l_intra_order_id mtl_txn_request_headers.header_id%TYPE;

1496: l_inter_line_id oe_order_lines_all.source_document_line_id%TYPE;
1497: l_header_id oe_order_headers_all.header_id%TYPE;
1498: l_line_id oe_order_lines_all.line_id%TYPE;
1499: l_intra_order_num mtl_txn_request_headers.request_number%TYPE;
1500: l_intra_order_id mtl_txn_request_headers.header_id%TYPE;
1501: l_intra_line_id mtl_txn_request_lines.line_id%TYPE;
1502: l_organization_id mtl_kanban_cards.organization_id%TYPE;
1503: l_source_type mtl_kanban_cards.source_type%TYPE;
1504: l_kanban_size mtl_kanban_cards.kanban_size%TYPE;