DBA Data[Home] [Help]

APPS.JAI_AP_RPT_APCR_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 1050: from JAI_AP_MATCH_INV_TAXES

1046: p_invoice_id number,
1047: p_parent_distribution_id number,
1048: p_po_distribution_id number) is
1049: select distribution_line_number, tax_id
1050: from JAI_AP_MATCH_INV_TAXES
1051: where invoice_id = p_invoice_id
1052: and parent_invoice_distribution_id = p_parent_distribution_id
1053: and po_distribution_id = p_po_distribution_id
1054: union

Line 1056: from JAI_AP_MATCH_INV_TAXES

1052: and parent_invoice_distribution_id = p_parent_distribution_id
1053: and po_distribution_id = p_po_distribution_id
1054: union
1055: select distribution_line_number, tax_id
1056: from JAI_AP_MATCH_INV_TAXES
1057: where invoice_id = p_invoice_id
1058: and parent_invoice_distribution_id is null
1059: and po_distribution_id is null
1060: and (po_header_id, po_line_id, line_location_id)

Line 1099: from JAI_AP_MATCH_INV_TAXES

1095: where transaction_id = p_rcv_transaction_id)
1096: and tax_id not in
1097: (
1098: select tax_id
1099: from JAI_AP_MATCH_INV_TAXES
1100: where invoice_id = p_invoice_id
1101: and parent_invoice_distribution_id = p_parent_distribution_id
1102: and po_distribution_id = p_po_distribution_id
1103: union

Line 1105: from JAI_AP_MATCH_INV_TAXES

1101: and parent_invoice_distribution_id = p_parent_distribution_id
1102: and po_distribution_id = p_po_distribution_id
1103: union
1104: select tax_id
1105: from JAI_AP_MATCH_INV_TAXES
1106: where invoice_id = p_invoice_id
1107: and parent_invoice_distribution_id is null
1108: and po_distribution_id is null
1109: and (po_header_id, po_line_id, line_location_id)

Line 1138: from JAI_AP_MATCH_INV_TAXES

1134: where po_distribution_id = p_po_distribution_id)
1135: and tax_id not in
1136: (
1137: select tax_id
1138: from JAI_AP_MATCH_INV_TAXES
1139: where invoice_id = p_invoice_id
1140: and parent_invoice_distribution_id = p_parent_distribution_id
1141: and po_distribution_id = p_po_distribution_id
1142: union

Line 1144: from JAI_AP_MATCH_INV_TAXES

1140: and parent_invoice_distribution_id = p_parent_distribution_id
1141: and po_distribution_id = p_po_distribution_id
1142: union
1143: select tax_id
1144: from JAI_AP_MATCH_INV_TAXES
1145: where invoice_id = p_invoice_id
1146: and parent_invoice_distribution_id is null
1147: and po_distribution_id is null
1148: and (po_header_id, po_line_id, line_location_id)