APPS.FLM_KANBAN_TRANSFER dependencies on OE_ORDER_HEADERS_ALL

Line 1126: FROM oe_order_headers_all oeh,

1122: wdd.ship_tolerance_above,
1123: oel.flow_status_code flow_status_code,
1124: oel.line_id line_id,
1125: oel.header_id header_id
1126: FROM oe_order_headers_all oeh,
1127: oe_order_lines_all oel ,
1128: wsh_delivery_details wdd,
1129: mtl_kanban_cards mkc,
1130: mtl_kanban_card_activity mkca

Line 1494: l_inter_order_num oe_order_headers_all.order_number%TYPE;

1490:
1491: l_api_name CONSTANT VARCHAR2(30) := 'complete_process';
1492: l_log_module CONSTANT VARCHAR2(80) := G_LOG_MODULE || l_api_name;
1493:
1494: l_inter_order_num oe_order_headers_all.order_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;

Line 1495: l_inter_order_id oe_order_headers_all.source_document_id%TYPE;

1491: l_api_name CONSTANT VARCHAR2(30) := 'complete_process';
1492: l_log_module CONSTANT VARCHAR2(80) := G_LOG_MODULE || l_api_name;
1493:
1494: l_inter_order_num oe_order_headers_all.order_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;

Line 1497: l_header_id oe_order_headers_all.header_id%TYPE;

1493:
1494: l_inter_order_num oe_order_headers_all.order_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;