APPS.CSE_PO_RECEIPT_INTO_PROJECT dependencies on PO_DISTRIBUTIONS_ALL

Line 578: po_distributions_all pda,

574: pla.item_revision item_revision,
575: to_char(pla.line_num) po_line_number,
576: pha.segment1 po_number
577: FROM rcv_transactions rt,
578: po_distributions_all pda,
579: po_line_locations_all plla,
580: po_lines_all pla,
581: po_headers_all pha
582: WHERE rt.transaction_id = p_rcv_txn_id

Line 802: FROM po_distributions_all pod,

798: pod.expenditure_type Expenditure_Type,
799: pod.expenditure_organization_id Expenditure_Org_Id,
800: pod.code_combination_id Dr_CC_Id,
801: hr.Name Expenditure_Organization_Name
802: FROM po_distributions_all pod,
803: hr_organization_units hr
804: WHERE pod.po_distribution_id = p_po_distribution_id
805: AND hr.organization_id = pod.Expenditure_Organization_Id;
806:

Line 910: FROM po_distributions_all pod, rcv_transactions rt

906: debug('rcv_transaction_id: ' || p_rcv_txn_tbl(i).rcv_transaction_id);
907: BEGIN
908: SELECT rt.transaction_date, pod.org_id
909: INTO rt_date, l_org_id
910: FROM po_distributions_all pod, rcv_transactions rt
911: WHERE rt.PO_DISTRIBUTION_ID=pod.po_distribution_id
912: AND rt.transaction_id = p_rcv_txn_tbl(i).rcv_transaction_id;
913:
914: l_gl_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(rt_date, l_org_id);