[Home] [Help]
113: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID
114: AND b.site_use_code = 'SHIP_TO'
115: AND a.party_site_id = c.party_site_id
116: AND a.cust_account_id = cp_cust_acct_id
117: AND a.org_id = MO_GLOBAL.get_current_org_id --NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99) sechawla 09-mar-11 11717200
118: AND c.party_site_id = cp_inst_loc_id
119: AND c.location_id = cp_loc_id;
120:
121: l_inst_loc_id NUMBER;
8405: FROM zx_lines zx,
8406: zx_lines_det_factors zxdet
8407: WHERE zx.trx_line_id = cp_trx_line_id
8408: AND zx.trx_id = cp_trx_id
8409: AND zx.internal_organization_id = MO_GLOBAL.get_current_org_id
8410: AND zx.entity_code = G_AR_ENTITY_CODE
8411: AND zx.event_class_code = G_INVOICE_EVENT_CLASS_CODE
8412: AND zx.application_id = G_AR_APPLICATION_ID
8413: AND zx.trx_line_id = zxdet.trx_line_id
8468: FROM zx_lines zx,
8469: zx_lines_det_factors zxdet
8470: WHERE zx.trx_id = cp_trx_id
8471: AND zx.trx_line_id = cp_trx_line_id
8472: AND zx.internal_organization_id = MO_GLOBAL.get_current_org_id
8473: AND zx.entity_code = G_AR_ENTITY_CODE
8474: AND zx.event_class_code = G_INVOICE_EVENT_CLASS_CODE
8475: AND zx.application_id = G_AR_APPLICATION_ID
8476: AND zx.trx_line_id = zxdet.trx_line_id
10032: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
10033: SELECT fma_id
10034: FROM okl_tax_basis_override
10035: WHERE try_id = cp_try_id
10036: AND org_id = MO_GLOBAL.get_current_org_id;
10037:
10038: -- GET FORMULA NAME
10039: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
10040: SELECT name
11020: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
11021: SELECT fma_id
11022: FROM okl_tax_basis_override
11023: WHERE try_id = cp_try_id
11024: AND org_id = MO_GLOBAL.get_current_org_id;
11025:
11026: -- get the inventory item id and inventory item org for a financial asset
11027: CURSOR l_invitem_csr(cp_fin_asset_id IN NUMBER) IS
11028: SELECT cim_model.object1_id1,
11088: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID
11089: AND b.site_use_code = 'SHIP_TO'
11090: AND a.party_site_id = c.party_site_id
11091: AND a.cust_account_id = cp_cust_acct_id
11092: AND a.org_id = MO_GLOBAL.get_current_org_id
11093: AND c.party_site_id = cp_inst_loc_id
11094: AND c.location_id = cp_loc_id;
11095:
11096: SUBTYPE txsv_rec_type IS okl_txs_pvt.txsv_rec_type;
13361: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
13362: SELECT fma_id
13363: FROM okl_tax_basis_override
13364: WHERE try_id = cp_try_id
13365: AND org_id = MO_GLOBAL.get_current_org_id;
13366:
13367: -- GET FORMULA NAME
13368: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
13369: SELECT name
15876: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
15877: SELECT fma_id
15878: FROM okl_tax_basis_override
15879: WHERE try_id = cp_try_id
15880: AND org_id = MO_GLOBAL.get_current_org_id;
15881:
15882: -- GET FORMULA NAME
15883: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
15884: SELECT name
15924: WHERE a.cust_acct_site_id = b.cust_acct_site_id
15925: AND b.site_use_code = 'SHIP_TO'
15926: AND a.party_site_id = c.party_site_id
15927: AND a.cust_account_id = cp_cust_acct_id
15928: AND a.org_id = MO_GLOBAL.get_current_org_id
15929: AND c.party_site_id = cp_inst_loc_id
15930: AND c.location_id = cp_loc_id;
15931:
15932: TYPE asset_level_det_rec_type IS RECORD
17662: RAISE OKL_API.G_EXCEPTION_ERROR;
17663: END IF;
17664:
17665: l_source_table := upper(p_source_table);
17666: l_org_id := mo_global.get_current_org_id;
17667:
17668: -- Get the OU Tax options
17669: OPEN l_systemparams_csr(cp_org_id => l_org_id);
17670: FETCH l_systemparams_csr INTO l_ou_tax_upfront_yn, l_ou_tax_invoice_yn;
19168: CURSOR l_txbasisoverride_csr(cp_try_id IN NUMBER) IS
19169: SELECT fma_id
19170: FROM okl_tax_basis_override
19171: WHERE try_id = cp_try_id
19172: AND org_id = MO_GLOBAL.get_current_org_id;
19173:
19174: -- get formula name
19175: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
19176: SELECT name