APPS.JAI_AP_RPT_APCR_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 1016: from po_distributions_all

1012: trunc(creation_date) po_date
1013: from po_headers_all
1014: where po_header_id =
1015: ( select po_header_id
1016: from po_distributions_all
1017: where po_distribution_id = p_po_distribution_id);
1018:
1019: cursor c_get_po_release (p_po_distribution_id number) is
1020: select release_num, release_date

Line 1029: from po_distributions_all

1025: from po_line_locations_all
1026: where (po_header_id, po_line_id, line_location_id ) in
1027: (
1028: select po_header_id, po_line_id, line_location_id
1029: from po_distributions_all
1030: where po_distribution_id = p_po_distribution_id
1031: )
1032: );
1033:

Line 1064: from po_distributions_all

1060: and (po_header_id, po_line_id, line_location_id)
1061: in
1062: (
1063: select po_header_id, po_line_id, line_location_id
1064: from po_distributions_all
1065: where po_distribution_id = p_po_distribution_id
1066: );
1067:
1068: cursor c_get_tax_type(p_tax_id number) is

Line 1113: from po_distributions_all

1109: and (po_header_id, po_line_id, line_location_id)
1110: in
1111: (
1112: select po_header_id, po_line_id, line_location_id
1113: from po_distributions_all
1114: where po_distribution_id = p_po_distribution_id
1115: )
1116: )
1117: ;

Line 1133: from po_distributions_all

1129: from JAI_PO_TAXES
1130: where (po_header_id, po_line_id, line_location_id)
1131: in
1132: (select po_header_id, po_line_id, line_location_id
1133: from po_distributions_all
1134: where po_distribution_id = p_po_distribution_id)
1135: and tax_id not in
1136: (
1137: select tax_id

Line 1152: from po_distributions_all

1148: and (po_header_id, po_line_id, line_location_id)
1149: in
1150: (
1151: select po_header_id, po_line_id, line_location_id
1152: from po_distributions_all
1153: where po_distribution_id = p_po_distribution_id
1154: )
1155: );
1156: