APPS.INV_KANBAN_PKG dependencies on MTL_TXN_REQUEST_LINES

Line 118: FROM mtl_txn_request_headers h, mtl_txn_request_lines l

114: AND h.requisition_header_id = l.requisition_header_id;
115: ELSIF v_document_type_id = 4 THEN /* Move Order */
116: SELECT h.request_number
117: INTO v_document_header
118: FROM mtl_txn_request_headers h, mtl_txn_request_lines l
119: WHERE l.line_id = v_document_detail_id
120: AND h.header_id = l.header_id;
121: ELSIF v_document_type_id = 5 THEN /* Wip Discrete Job */
122: SELECT h.wip_entity_name

Line 767: FROM mtl_txn_request_lines m

763: SELECT * FROM (SELECT m.line_id
764: , m.reference_type_code
765: , m.line_status
766: , (NVL(quantity_delivered, 0)- m.quantity) qty_diff
767: FROM mtl_txn_request_lines m
768: , mtl_kanban_cards k
769: WHERE m.reference_id = k.kanban_card_id
770: AND m.organization_id = p_organization_id
771: AND k.kanban_card_number = p_kanban_number