DBA Data[Home] [Help]

APPS.JMF_GTA_REPORTS_PKG dependencies on JMF_GTA_UNMATCHED_TEMP

Line 3468: --table jmf_gta_unmatched_temp

3464: WHILE c_gta_unmatched_line%FOUND
3465: LOOP
3466:
3467: --INSERT unmatched GTA lines belong to current AR to temp
3468: --table jmf_gta_unmatched_temp
3469: INSERT INTO jmf_gta_unmatched_temp(source
3470: ,ar_header_id
3471: ,invoice_number
3472: ,tp_tax_registration_number

Line 3469: INSERT INTO jmf_gta_unmatched_temp(source

3465: LOOP
3466:
3467: --INSERT unmatched GTA lines belong to current AR to temp
3468: --table jmf_gta_unmatched_temp
3469: INSERT INTO jmf_gta_unmatched_temp(source
3470: ,ar_header_id
3471: ,invoice_number
3472: ,tp_tax_registration_number
3473: ,line_number

Line 3510: --table jmf_gta_unmatched_temp

3506: WHILE c_gt_unmatched_line%FOUND
3507: LOOP
3508:
3509: --INSERT unmatched GT lines belong to current AR to temp
3510: --table jmf_gta_unmatched_temp
3511: INSERT INTO jmf_gta_unmatched_temp(source
3512: ,ar_header_id
3513: ,invoice_number
3514: ,tp_tax_registration_number

Line 3511: INSERT INTO jmf_gta_unmatched_temp(source

3507: LOOP
3508:
3509: --INSERT unmatched GT lines belong to current AR to temp
3510: --table jmf_gta_unmatched_temp
3511: INSERT INTO jmf_gta_unmatched_temp(source
3512: ,ar_header_id
3513: ,invoice_number
3514: ,tp_tax_registration_number
3515: ,line_number

Line 3870: jmf_gta_unmatched_temp

3866: )
3867: )
3868:
3869: FROM
3870: jmf_gta_unmatched_temp
3871: WHERE ar_header_id=l_ar_header_id
3872: ORDER BY source DESC;
3873:
3874: CURSOR c_missing_artrx_xml IS