APPS.PO_ACCOUNT_HELPER dependencies on PO_DISTRIBUTIONS_MERGE_V

Line 1086: FROM PO_DISTRIBUTIONS_MERGE_V pod,

1082: poh.attribute12 header_attribute12,
1083: poh.attribute13 header_attribute13,
1084: poh.attribute14 header_attribute14,
1085: poh.attribute15 header_attribute15
1086: FROM PO_DISTRIBUTIONS_MERGE_V pod,
1087: PO_LINE_LOCATIONS_MERGE_V poll,
1088: PO_LINES_MERGE_V pol,
1089: PO_HEADERS_MERGE_V poh
1090: WHERE pod.po_line_id = poll.po_line_id

Line 1962: -- po_distributions_merge_v to consider all possible values for ACRNs.

1958: -- None.
1959: --Function:
1960: -- Derive ACRN for Award and Modification/ PAR via BWC
1961: -- capture all the distribution ids and their related data from
1962: -- po_distributions_merge_v to consider all possible values for ACRNs.
1963: -- CALL the BUILD_ACRN API to get the acrns
1964: -- Return the values to the calling programs.
1965: --Parameters:
1966: --IN:

Line 2096: -- INSERT INTO PO_SESSION_GT all the values available from po_distributions_merge_v

2092: PO_LOG.stmt(d_module,d_position,'No Of records ',l_count);
2093: END IF;
2094:
2095:
2096: -- INSERT INTO PO_SESSION_GT all the values available from po_distributions_merge_v
2097: -- THIS IS TO MAKE SURE THAT WE WILL CONSIDER ALL DISTRIBUTIONS FOR THAT DOCUMENT.
2098: INSERT INTO po_session_gt
2099: (KEY,
2100: num1,

Line 2113: FROM po_distributions_merge_v

2109: clm_misc_loa,
2110: Nvl(clm_misc_loa, code_combination_id),
2111: change_status,
2112: acrn
2113: FROM po_distributions_merge_v
2114: WHERE po_header_id = p_header_id;
2115:
2116: l_count := SQL%rowcount;
2117: d_position := 20;