DBA Data[Home] [Help]

APPS.JAI_AP_RPT_APCR_PKG dependencies on JAI_AP_MATCH_INV_TAXES

Line 1008: from JAI_AP_MATCH_INV_TAXES

1004: p_invoice_id number,
1005: p_parent_distribution_id number,
1006: p_po_distribution_id number) is
1007: select distribution_line_number, tax_id
1008: from JAI_AP_MATCH_INV_TAXES
1009: where invoice_id = p_invoice_id
1010: and parent_invoice_distribution_id = p_parent_distribution_id
1011: and po_distribution_id = p_po_distribution_id
1012: union

Line 1014: from JAI_AP_MATCH_INV_TAXES

1010: and parent_invoice_distribution_id = p_parent_distribution_id
1011: and po_distribution_id = p_po_distribution_id
1012: union
1013: select distribution_line_number, tax_id
1014: from JAI_AP_MATCH_INV_TAXES
1015: where invoice_id = p_invoice_id
1016: and parent_invoice_distribution_id is null
1017: and po_distribution_id is null
1018: and (po_header_id, po_line_id, line_location_id)

Line 1057: from JAI_AP_MATCH_INV_TAXES

1053: where transaction_id = p_rcv_transaction_id)
1054: and tax_id not in
1055: (
1056: select tax_id
1057: from JAI_AP_MATCH_INV_TAXES
1058: where invoice_id = p_invoice_id
1059: and parent_invoice_distribution_id = p_parent_distribution_id
1060: and po_distribution_id = p_po_distribution_id
1061: union

Line 1063: from JAI_AP_MATCH_INV_TAXES

1059: and parent_invoice_distribution_id = p_parent_distribution_id
1060: and po_distribution_id = p_po_distribution_id
1061: union
1062: select tax_id
1063: from JAI_AP_MATCH_INV_TAXES
1064: where invoice_id = p_invoice_id
1065: and parent_invoice_distribution_id is null
1066: and po_distribution_id is null
1067: and (po_header_id, po_line_id, line_location_id)

Line 1096: from JAI_AP_MATCH_INV_TAXES

1092: where po_distribution_id = p_po_distribution_id)
1093: and tax_id not in
1094: (
1095: select tax_id
1096: from JAI_AP_MATCH_INV_TAXES
1097: where invoice_id = p_invoice_id
1098: and parent_invoice_distribution_id = p_parent_distribution_id
1099: and po_distribution_id = p_po_distribution_id
1100: union

Line 1102: from JAI_AP_MATCH_INV_TAXES

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