APPS.BIL_TX_OPTY_SMRY_RPT_PKG dependencies on BIL_TX_PROD_TMP

Line 277: EXECUTE IMMEDIATE 'TRUNCATE TABLE'||' '||l_schema||'.'||'BIL_TX_PROD_TMP ';

273:
274:
275: --deletion of records from the Global Temporary Table --
276:
277: EXECUTE IMMEDIATE 'TRUNCATE TABLE'||' '||l_schema||'.'||'BIL_TX_PROD_TMP ';
278:
279:
280: --- product category parsing -----
281:

Line 299: INSERT INTO BIL_TX_PROD_TMP(attr1,attr2,attr3) VALUES(l_prodcat_id,l_item_id,'C');

295:
296: BIL_TX_UTIL_RPT_PKG.PARSE_PRODCAT_ITEM_ID(l_prodcat_id,l_item_id) ;
297:
298: IF l_item_id is null THEN
299: INSERT INTO BIL_TX_PROD_TMP(attr1,attr2,attr3) VALUES(l_prodcat_id,l_item_id,'C');
300: ELSE
301: INSERT INTO BIL_TX_PROD_TMP(attr1,attr2,attr3) VALUES(l_prodcat_id,l_item_id,'P');
302: END IF;
303:

Line 301: INSERT INTO BIL_TX_PROD_TMP(attr1,attr2,attr3) VALUES(l_prodcat_id,l_item_id,'P');

297:
298: IF l_item_id is null THEN
299: INSERT INTO BIL_TX_PROD_TMP(attr1,attr2,attr3) VALUES(l_prodcat_id,l_item_id,'C');
300: ELSE
301: INSERT INTO BIL_TX_PROD_TMP(attr1,attr2,attr3) VALUES(l_prodcat_id,l_item_id,'P');
302: END IF;
303:
304: l_product_category := substr(l_product_category, l_len+1);
305:

Line 324: , BIL_TX_PROD_TMP cat

320: , a.child_id
321: ,tl.description prodcat_name
322: FROM eni_denorm_hierarchies a
323: , mtl_default_category_sets b
324: , BIL_TX_PROD_TMP cat
325: , mtl_categories_tl tl
326: WHERE b.functional_area_id = 11
327: AND b.category_set_id = a.object_id
328: AND a.object_type = ''CATEGORY_SET''

Line 420: ,bil_tx_prod_tmp prod

416: -- Sales Rep Query From clause --
417:
418:
419: l_srep_frm_cls := ' FROM as_sales_credits_denorm ascd
420: ,bil_tx_prod_tmp prod
421: ,mtl_system_items_tl tl
422: ,jtf_rs_group_usages usg1
423: ,as_period_days p ';
424: -- Report By --