APPS.RCV_DISTRIBUTIONS_S dependencies on MTL_KANBAN_CARDS

Line 192: mtl_kanban_cards mkc --

188: x_task_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
189: l_code_combination_id --
190: FROM po_distributions pod,
191: hr_locations_all_tl hl,
192: mtl_kanban_cards mkc --
193: WHERE pod.line_location_id = X_line_location_id
194: AND pod.po_distribution_id = Nvl(X_PO_DISTRIBUTIONS_ID,pod.po_distribution_id) -- bug 9742420
195: AND hl.location_id(+) = pod.deliver_to_location_id
196: AND hl.language(+) = USERENV('LANG')

Line 718: mtl_kanban_cards MKC

714: x_rate_date
715: FROM po_distributions_all POD, -- Bug 10203707
716: --pjm_projects_all_v PPA,
717: --pa_tasks_expend_v PTE,
718: mtl_kanban_cards MKC
719: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,
720: POD.po_distribution_id)
721: AND POD.line_location_id = p_line_location_id
722: --AND POD.project_id = PPA.project_id (+)

Line 865: mtl_kanban_cards MKC

861: x_task_id, -- bug 3867151
862: x_charge_account
863: FROM po_requisition_lines PRL,
864: po_req_distributions PRD,
865: mtl_kanban_cards MKC
866: WHERE PRL.requisition_line_id = p_requisition_line_id
867: AND PRL.requisition_line_id = PRD.requisition_line_id
868: AND PRD.distribution_id = NVL(p_req_distribution_id,PRD.distribution_id)
869: AND PRL.kanban_card_id = MKC.kanban_card_id (+);