APPS.FLM_KANBAN_TRANSFER dependencies on MTL_KANBAN_CARDS

Line 1107: mtl_kanban_cards mkc

1103: CURSOR c_qty_on_hand(p_kanban_card_id IN NUMBER)
1104: IS
1105: SELECT SUM(moq.transaction_quantity) transaction_quantity
1106: FROM mtl_onhand_quantities moq,
1107: mtl_kanban_cards mkc
1108: WHERE mkc.inventory_item_id = moq.inventory_item_id
1109: AND mkc.SOURCE_organization_id = moq.organization_id
1110: AND mkc.source_subinventory = moq.subinventory_code
1111: AND NVL(mkc.SOURCE_LOCATOR_ID, 1) = NVL(moq.locator_id, 1)

Line 1129: mtl_kanban_cards mkc,

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
1131: WHERE oeh.source_document_id = mkca.document_header_id
1132: AND oeh.header_id = oel.header_id
1133: AND oel.source_document_line_id = mkca.document_detail_id

Line 1153: mtl_kanban_cards mkc,

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
1156: AND mtrl.line_id = mkca.document_detail_id
1157: AND mtrh.header_status = mtrl.line_status

Line 1179: FROM mtl_kanban_cards mkc

1175: mkc.locator_id,
1176: mkc.source_organization_id,
1177: mkc.source_subinventory,
1178: mkc.source_locator_id
1179: FROM mtl_kanban_cards mkc
1180: WHERE mkc.kanban_card_id = p_kanban_card_id;
1181:
1182: -- Cursor to fetch item details . Added For Bug 12921002.
1183: CURSOR c_item_details(p_item_id IN NUMBER, p_organization_id IN NUMBER)

Line 1502: l_organization_id mtl_kanban_cards.organization_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;
1505:
1506: BEGIN

Line 1503: l_source_type mtl_kanban_cards.source_type%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;
1505:
1506: BEGIN
1507:

Line 1504: l_kanban_size mtl_kanban_cards.kanban_size%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;
1505:
1506: BEGIN
1507:
1508: SAVEPOINT complete_process;