APPS.FLM_RECEIPT_PUB dependencies on MTL_KANBAN_CARD_ACTIVITY

Line 97: mtl_kanban_card_activity mkca

93: FROM po_headers_all poh,
94: po_line_locations_all poll,
95: po_distributions_all pod,
96: mtl_kanban_cards mkc,
97: mtl_kanban_card_activity mkca
98: WHERE poh.po_header_id = pod.po_header_id
99: AND poll.line_location_id = pod.line_location_id
100: AND pod.po_distribution_id = mkca.document_detail_id
101: AND mkca.kanban_card_id = mkc.kanban_card_id

Line 113: mtl_kanban_card_activity mkca

109: SUM(rsl.quantity_shipped) quantity_shipped,
110: SUM(rsl.quantity_received) quantity_received
111: FROM rcv_shipment_lines rsl,
112: mtl_kanban_cards mkc,
113: mtl_kanban_card_activity mkca
114: WHERE rsl.requisition_line_id = mkca.document_detail_id
115: AND mkca.kanban_card_id = mkc.kanban_card_id
116: AND mkca.replenishment_cycle_id = mkc.current_replnsh_cycle_id
117: AND mkc.kanban_card_id = p_kanban_card_id;

Line 518: mtl_kanban_card_activity mkca

514: po_distributions_all pod,
515: mtl_system_items_vl msi,
516: mtl_units_of_measure muom,
517: mtl_kanban_cards mkc,
518: mtl_kanban_card_activity mkca
519: WHERE poh.po_header_id = pol.po_header_id
520: AND pol.po_line_id = poll.po_line_id
521: AND poll.line_location_id = pod.line_location_id
522: AND pod.po_distribution_id = mkca.document_detail_id

Line 932: mtl_kanban_card_activity mkca

928: po_requisition_lines_all porl,
929: mtl_system_items msi,
930: mtl_units_of_measure muom,
931: mtl_kanban_cards mkc,
932: mtl_kanban_card_activity mkca
933: WHERE rsl.requisition_line_id = porl.requisition_line_id
934: AND rsl.requisition_line_id = mkca.document_detail_id
935: AND msi.inventory_item_id = mkc.inventory_item_id
936: AND msi.organization_id = mkc.organization_id