APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ITEMORG_LSTG

Line 377: l_staging_table_name VARCHAR2(30) :='EDW_ITEM_ITEMORG_LSTG' ;

373: PROCEDURE Push_EDW_ITEM_ITEMORG(
374: p_from_date IN DATE,
375: p_to_date IN DATE) IS
376:
377: l_staging_table_name VARCHAR2(30) :='EDW_ITEM_ITEMORG_LSTG' ;
378: L_PUSH_DATE_RANGE1 DATE := NULL;
379: L_PUSH_DATE_RANGE2 DATE := NULL;
380: l_rows_inserted NUMBER := 0;
381: l_commit_count NUMBER := 0;

Line 791: INSERT INTO EDW_ITEM_ITEMORG_LSTG(

787:
788: edw_log.put_line('Inserting TEMP table records into staging table');
789: edw_log.put_line(' ');
790:
791: INSERT INTO EDW_ITEM_ITEMORG_LSTG(
792: APPROVED_SUPPLIER,
793: BUYER_FK,
794: CREATION_DATE,
795: CATSET_CATEGORY_FK,

Line 920: INSERT INTO EDW_ITEM_ITEMORG_LSTG(

916:
917: edw_log.put_line(' ');
918: edw_log.put_line('Pushing EDW_ITEM_ITEMORG for one time items');
919:
920: INSERT INTO EDW_ITEM_ITEMORG_LSTG(
921: APPROVED_SUPPLIER,
922: BUYER_FK,
923: CREATION_DATE,
924: CATSET_CATEGORY_FK,

Line 1487: INSERT INTO edw_item_itemorg_lstg(

1483: COMMIT;
1484:
1485: edw_log.put_line('Pushing EDW_ITEM_ITEM records to Item Org level');
1486:
1487: INSERT INTO edw_item_itemorg_lstg(
1488: ITEM_ORG_PK,
1489: ITEM_NUMBER_FK,
1490: INVENTORY_ITEM_ID,
1491: ORGANIZATION_ID,

Line 1615: INSERT INTO edw_item_itemorg_lstg(

1611: COMMIT;
1612:
1613: edw_log.put_line('Pushing one-time EDW_ITEM_ITEM records to Item Org level');
1614:
1615: INSERT INTO edw_item_itemorg_lstg(
1616: ITEM_ORG_PK,
1617: ITEM_NUMBER_FK,
1618: NAME,
1619: INSTANCE,

Line 3100: INSERT INTO EDW_ITEM_ITEMORG_LSTG(

3096: FOR l_itemrev_rec IN l_itemrev_csr(l_itemorg_catset1_name) LOOP
3097: l_catset_category_fk := TO_CHAR(l_control_level)||'-'||l_itemrev_rec.CATEGORY_PK;
3098: l_level_name := '-COCT';
3099:
3100: INSERT INTO EDW_ITEM_ITEMORG_LSTG(
3101: ITEM_ORG_PK,
3102: CATSET_CATEGORY_FK,
3103: NAME,
3104: INSTANCE,

Line 3213: INSERT INTO EDW_ITEM_ITEMORG_LSTG(

3209: l_itemrev_rec.CATEGORY_SET_ID,
3210: l_itemrev_rec.last_update_date
3211: );
3212:
3213: INSERT INTO EDW_ITEM_ITEMORG_LSTG(
3214: ITEM_ORG_PK,
3215: ITEM_NUMBER_FK,
3216: INSTANCE,
3217: NAME,

Line 3300: INSERT INTO EDW_ITEM_ITEMORG_LSTG(

3296: l_itemrev_rec.CATEGORY_SET_ID,
3297: l_itemrev_rec.last_update_date
3298: );
3299:
3300: INSERT INTO EDW_ITEM_ITEMORG_LSTG(
3301: ITEM_ORG_PK,
3302: ITEM_NUMBER_FK,
3303: INSTANCE,
3304: NAME,

Line 3527: INSERT INTO EDW_ITEM_ITEMORG_LSTG(

3523: edw_log.put_line(' ');
3524:
3525: edw_log.put_line('Pushing Product Line to lower level EDW_ITEM_ITEMORG');
3526:
3527: INSERT INTO EDW_ITEM_ITEMORG_LSTG(
3528: ITEM_ORG_PK,
3529: ITEM_NUMBER_FK,
3530: NAME,
3531: INSTANCE,

Line 3695: INSERT INTO EDW_ITEM_ITEMORG_LSTG(

3691: edw_log.put_line(' ');
3692:
3693: edw_log.put_line('Pushing Product Category to lower level EDW_ITEM_ITEMORG');
3694:
3695: INSERT INTO EDW_ITEM_ITEMORG_LSTG(
3696: ITEM_ORG_PK,
3697: ITEM_NUMBER_FK,
3698: NAME,
3699: INSTANCE,

Line 3840: INSERT INTO EDW_ITEM_ITEMORG_LSTG(

3836: edw_log.put_line(' ');
3837:
3838: edw_log.put_line('Pushing Product Group to lower level EDW_ITEM_ITEMORG');
3839:
3840: INSERT INTO EDW_ITEM_ITEMORG_LSTG(
3841: ITEM_ORG_PK,
3842: ITEM_NUMBER_FK,
3843: NAME,
3844: INSTANCE,