DBA Data[Home] [Help]

APPS.JL_VENDORMERGE_GRP dependencies on JL_BR_AP_COLLECTION_DOCS_ALL

Line 81: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id

77: Update JL_ZZ_AP_SUPP_AWT_TYPES
78: set vendor_id = p_vendor_id
79: where vendor_id = p_dup_vendor_id;
80:
81: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
82: Update JL_BR_AP_COLLECTION_DOCS_ALL
83: set vendor_id = p_vendor_id
84: where vendor_id = p_dup_vendor_id;
85:

Line 82: Update JL_BR_AP_COLLECTION_DOCS_ALL

78: set vendor_id = p_vendor_id
79: where vendor_id = p_dup_vendor_id;
80:
81: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
82: Update JL_BR_AP_COLLECTION_DOCS_ALL
83: set vendor_id = p_vendor_id
84: where vendor_id = p_dup_vendor_id;
85:
86: -- Update JL_BR_AP_CONSOLID_INVOICES_ALL - vendor_id

Line 99: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id

95:
96: ELSif p_dup_vendor_id is not null and p_dup_vendor_site_id is not null
97: and p_vendor_id is not null and p_vendor_site_id is not null Then
98:
99: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
100: Update JL_BR_AP_COLLECTION_DOCS_ALL
101: set vendor_id = p_vendor_id,
102: vendor_site_id = p_vendor_site_id
103: where vendor_id = p_dup_vendor_id

Line 100: Update JL_BR_AP_COLLECTION_DOCS_ALL

96: ELSif p_dup_vendor_id is not null and p_dup_vendor_site_id is not null
97: and p_vendor_id is not null and p_vendor_site_id is not null Then
98:
99: -- Update JL_BR_AP_COLLECTION_DOCS_ALL - vendor_id
100: Update JL_BR_AP_COLLECTION_DOCS_ALL
101: set vendor_id = p_vendor_id,
102: vendor_site_id = p_vendor_site_id
103: where vendor_id = p_dup_vendor_id
104: and vendor_site_id = p_dup_vendor_site_id;