APPS.JAI_AP_RPT_APCR_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 974: from po_distributions_all

970: trunc(creation_date) po_date
971: from po_headers_all
972: where po_header_id =
973: ( select po_header_id
974: from po_distributions_all
975: where po_distribution_id = p_po_distribution_id);
976:
977: cursor c_get_po_release (p_po_distribution_id number) is
978: select release_num, release_date

Line 987: from po_distributions_all

983: from po_line_locations_all
984: where (po_header_id, po_line_id, line_location_id ) in
985: (
986: select po_header_id, po_line_id, line_location_id
987: from po_distributions_all
988: where po_distribution_id = p_po_distribution_id
989: )
990: );
991:

Line 1022: from po_distributions_all

1018: and (po_header_id, po_line_id, line_location_id)
1019: in
1020: (
1021: select po_header_id, po_line_id, line_location_id
1022: from po_distributions_all
1023: where po_distribution_id = p_po_distribution_id
1024: );
1025:
1026: cursor c_get_tax_type(p_tax_id number) is

Line 1071: from po_distributions_all

1067: and (po_header_id, po_line_id, line_location_id)
1068: in
1069: (
1070: select po_header_id, po_line_id, line_location_id
1071: from po_distributions_all
1072: where po_distribution_id = p_po_distribution_id
1073: )
1074: )
1075: ;

Line 1091: from po_distributions_all

1087: from JAI_PO_TAXES
1088: where (po_header_id, po_line_id, line_location_id)
1089: in
1090: (select po_header_id, po_line_id, line_location_id
1091: from po_distributions_all
1092: where po_distribution_id = p_po_distribution_id)
1093: and tax_id not in
1094: (
1095: select tax_id

Line 1110: from po_distributions_all

1106: and (po_header_id, po_line_id, line_location_id)
1107: in
1108: (
1109: select po_header_id, po_line_id, line_location_id
1110: from po_distributions_all
1111: where po_distribution_id = p_po_distribution_id
1112: )
1113: );
1114: