[Home] [Help]
69: mkc.card_status,
70: mkc.source_type,
71: mkc.inventory_item_id,
72: mkc.organization_id
73: FROM mtl_kanban_cards mkc
74: WHERE mkc.kanban_card_id = p_kanban_card_id;
75:
76: -- Cursor to fetch item details
77: CURSOR c_item_details(p_item_id IN NUMBER, p_organization_id IN NUMBER)
92: pod.quantity_delivered
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
108: SELECT COUNT(rsl.shipment_line_id) num_of_ship_lines,
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
513: po_line_locations_all poll,
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
927: FROM rcv_shipment_lines rsl,
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
1412:
1413: CURSOR c_get_kanban_source_type(p_kanban_card_id IN NUMBER)
1414: IS
1415: SELECT source_type
1416: FROM mtl_kanban_cards
1417: WHERE kanban_card_id = p_kanban_card_id;
1418:
1419: l_source_type NUMBER;
1420: l_ret_msg_code NUMBER;