APPS.RCV_DISTRIBUTIONS_S dependencies on MTL_KANBAN_CARDS

Line 142: mtl_kanban_cards mkc --

138: x_task_id, -- Bug 4684017 The variable should be x_project_id and not x_project_number
139: l_code_combination_id --
140: FROM po_distributions pod,
141: hr_locations_all_tl hl,
142: mtl_kanban_cards mkc --
143: WHERE pod.line_location_id = X_line_location_id
144: AND hl.location_id(+) = pod.deliver_to_location_id
145: AND hl.language(+) = USERENV('LANG')
146: AND pod.kanban_card_id = mkc.kanban_card_id (+); --

Line 667: mtl_kanban_cards MKC

663: x_rate_date
664: FROM po_distributions POD,
665: --pjm_projects_all_v PPA,
666: --pa_tasks_expend_v PTE,
667: mtl_kanban_cards MKC
668: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,
669: POD.po_distribution_id)
670: AND POD.line_location_id = p_line_location_id
671: --AND POD.project_id = PPA.project_id (+)

Line 814: mtl_kanban_cards MKC

810: x_task_id, -- bug 3867151
811: x_charge_account
812: FROM po_requisition_lines PRL,
813: po_req_distributions PRD,
814: mtl_kanban_cards MKC
815: WHERE PRL.requisition_line_id = p_requisition_line_id
816: AND PRL.requisition_line_id = PRD.requisition_line_id
817: AND PRD.distribution_id = NVL(p_req_distribution_id,PRD.distribution_id)
818: AND PRL.kanban_card_id = MKC.kanban_card_id (+);