APPS.ZX_JL_EXTRACT_PKG dependencies on HZ_CUST_ACCOUNTS

Line 7879: | This function returns the Primary Validation Digit from hz_cust_accounts |

7875: | GET_VALIDATION_DIGIT |
7876: | Type : Private |
7877: | Pre-req : None |
7878: | Function : |
7879: | This function returns the Primary Validation Digit from hz_cust_accounts |
7880: | table to meet the requirement of Argentine Receivables VAT Sales Report |
7881: | |
7882: | Called from ZX_JL_EXTRACT_PKG.POPULATE_JL_AR |
7883: | |

Line 7915: hz_cust_accounts cust

7911: BEGIN
7912: SELECT substr(cust.global_attribute12,1,1)
7913: INTO x_validation_digit_tbl(i)
7914: FROM zx_rep_trx_detail_t det,
7915: hz_cust_accounts cust
7916: WHERE det.request_id = p_request_id
7917: AND det.trx_id = p_trx_id_tbl(i)
7918: AND cust.cust_account_id = nvl( det.shipping_trading_partner_id,det.billing_trading_partner_id )
7919: AND ROWNUM = 1;

Line 8046: hz_cust_accounts cust,

8042: INTO l_address_id,
8043: l_contributor_class,
8044: l_use_site_prof
8045: FROM ra_customer_trx_all trx,
8046: hz_cust_accounts cust,
8047: hz_cust_acct_sites_all add1,
8048: hz_cust_site_uses_all site
8049: WHERE trx.customer_trx_id = p_trx_id_tbl(i)
8050: AND cust.cust_account_id = nvl(trx.ship_to_customer_id,trx.bill_to_customer_id)

Line 8366: hz_cust_accounts cust,

8362: INTO l_address_id,
8363: l_class_code,
8364: l_use_site_prof
8365: FROM ra_customer_trx_all trx,
8366: hz_cust_accounts cust,
8367: hz_cust_acct_sites_all add1,
8368: hz_cust_site_uses_all site
8369: WHERE trx.customer_trx_id = p_trx_id_tbl(i)
8370: AND cust.cust_account_id = NVL(trx.ship_to_customer_id,trx.bill_to_customer_id)