APPS.FLM_KANBANCARD_PUB dependencies on MTL_KANBAN_CARDS

Line 83: from mtl_kanban_cards where

79: return;
80: end if;
81:
82: select kanban_card_id into l_kanban_card_id
83: from mtl_kanban_cards where
84: kanban_card_number = P_KANBAN_CARD_NUM
85: and organization_id = (select organization_id from mtl_parameters
86: where organization_code = P_ORG_CODE);
87:

Line 372: from mtl_kanban_cards

368: -- Should exclude NRK's and Temporary cards as well
369: -- Should exclude Plan cards as well. Bug 12615793.
370: select count(1)
371: into l_active_cards_count
372: from mtl_kanban_cards
373: where card_status in (INV_Kanban_PVT.G_Card_Status_Active,INV_Kanban_PVT.G_Card_Status_Hold)
374: and pull_sequence_id = p_pull_sequence_id
375: and kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
376: and max_replenishments is null

Line 1037: mtl_kanban_cards mkc

1033: SELECT Nvl(pda.quantity_delivered,0)
1034: INTO l_total_received_quantity
1035: FROM mtl_kanban_card_activity mkca,
1036: po_distributions_all pda,
1037: mtl_kanban_cards mkc
1038: WHERE mkc.kanban_card_id = p_Kanban_Card_Id
1039: AND mkca.document_type IS NOT NULL
1040: AND mkca.document_header_id IS NOT NULL
1041: AND mkca.document_header_id = pda.po_header_id

Line 1056: mtl_kanban_cards mkc

1052: into l_total_received_quantity
1053: from ( SELECT nvl(mmt.primary_quantity,0) qty
1054: FROM mtl_material_transactions mmt,
1055: mtl_kanban_card_activity mkca,
1056: mtl_kanban_cards mkc
1057: WHERE mkca.kanban_card_id = p_Kanban_Card_Id
1058: AND mkca.document_type IS NOT NULL
1059: AND mkca.document_header_id IS NOT NULL
1060: AND mmt.organization_id = l_kanban_card_rec.organization_id

Line 1084: from mtl_kanban_cards mkc,mtl_kanban_card_activity mkca

1080: into l_total_received_quantity
1081: from mtl_material_transactions mmt,
1082: oe_order_lines_all ool,
1083: (select mkca.document_header_id,mkca.document_detail_id
1084: from mtl_kanban_cards mkc,mtl_kanban_card_activity mkca
1085: where mkc.kanban_card_id = p_Kanban_Card_Id
1086: and mkc.kanban_card_id = mkca.kanban_card_id
1087: and mkc.current_replnsh_cycle_id = mkca.replenishment_cycle_id
1088: and mkca.document_header_id is not null

Line 1110: mtl_kanban_cards mkc

1106: select nvl(sum(primary_quantity),0)
1107: into l_total_received_quantity
1108: from rcv_transactions rt,
1109: mtl_kanban_card_activity mkca,
1110: mtl_kanban_cards mkc
1111: where rt.transaction_type = 'DELIVER'
1112: and rt.requisition_line_id = mkca.document_detail_id
1113: and rt.organization_id = mkc.organization_id
1114: and rt.subinventory = mkc.subinventory_name

Line 1130: mtl_kanban_cards mkc

1126: INTO l_total_received_quantity
1127: from ( SELECT nvl(mmt.primary_quantity,0) qty
1128: FROM mtl_material_transactions mmt,
1129: mtl_kanban_card_activity mkca,
1130: mtl_kanban_cards mkc
1131: WHERE mkca.kanban_card_id = p_Kanban_Card_Id
1132: AND mkca.document_type IS NOT NULL
1133: AND mkca.document_header_id IS NOT NULL
1134: AND mmt.organization_id = l_kanban_card_rec.organization_id