APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ITEMREV_LSTG

Line 226: l_staging_table_name VARCHAR2(30) :='EDW_ITEM_ITEMREV_LSTG' ;

222:
223: PROCEDURE Push_EDW_ITEM_ITEMREV(
224: p_from_date IN DATE,
225: p_to_date IN DATE) IS
226: l_staging_table_name VARCHAR2(30) :='EDW_ITEM_ITEMREV_LSTG' ;
227: L_PUSH_DATE_RANGE1 DATE:=NULL;
228: L_PUSH_DATE_RANGE2 DATE:=NULL;
229: l_rows_inserted NUMBER:=0;
230:

Line 239: INSERT INTO EDW_ITEM_ITEMREV_LSTG(

235:
236: edw_log.put_line(' ');
237: edw_log.put_line('Pushing EDW_ITEM_ITEMREV');
238:
239: INSERT INTO EDW_ITEM_ITEMREV_LSTG(
240: CREATION_DATE,
241: EFFECTIVE_DATE,
242: ERROR_CODE,
243: INSTANCE,

Line 1049: INSERT INTO EDW_ITEM_ITEMREV_LSTG(

1045: edw_log.put_line('Pushing items to lower level EDW_ITEM_ITEMREV');
1046: l_rows_inserted := 0;
1047: l_commit_count := 0;
1048:
1049: INSERT INTO EDW_ITEM_ITEMREV_LSTG(
1050: ITEM_REVISION_PK,
1051: ITEM_ORG_FK,
1052: INVENTORY_ITEM_ID,
1053: ORGANIZATION_ID,

Line 1080: INSERT INTO EDW_ITEM_ITEMREV_LSTG(

1076:
1077: l_rows_inserted := 0;
1078: edw_log.put_line('Pushing one time items to lower level EDW_ITEM_ITEMREV');
1079:
1080: INSERT INTO EDW_ITEM_ITEMREV_LSTG(
1081: ITEM_ORG_FK,
1082: ITEM_REVISION_PK,
1083: NAME,
1084: INSTANCE,

Line 1518: INSERT INTO edw_item_itemrev_lstg(

1514: COMMIT;
1515:
1516: edw_log.put_line('Pushing EDW_ITEM_ITEM records to Item Rev level');
1517:
1518: INSERT INTO edw_item_itemrev_lstg(
1519: ITEM_REVISION_PK,
1520: ITEM_ORG_FK,
1521: INVENTORY_ITEM_ID,
1522: ORGANIZATION_ID,

Line 1640: INSERT INTO edw_item_itemrev_lstg(

1636: ' rows into the staging table');
1637: edw_log.put_line(' ');
1638: COMMIT;
1639:
1640: INSERT INTO edw_item_itemrev_lstg(
1641: ITEM_REVISION_PK,
1642: ITEM_ORG_FK,
1643: NAME,
1644: INSTANCE,

Line 3126: INSERT INTO EDW_ITEM_ITEMREV_LSTG(

3122: );
3123:
3124: l_rows_inserted := l_rows_inserted + 1;
3125:
3126: INSERT INTO EDW_ITEM_ITEMREV_LSTG(
3127: ITEM_REVISION_PK,
3128: ITEM_ORG_FK,
3129: INSTANCE,
3130: NAME,

Line 3237: INSERT INTO EDW_ITEM_ITEMREV_LSTG(

3233: l_itemrev_rec.CATEGORY_SET_ID,
3234: l_itemrev_rec.last_update_date
3235: );
3236:
3237: INSERT INTO EDW_ITEM_ITEMREV_LSTG(
3238: ITEM_REVISION_PK,
3239: ITEM_ORG_FK,
3240: NAME,
3241: CATEGORY_ID,

Line 3324: INSERT INTO EDW_ITEM_ITEMREV_LSTG(

3320: l_itemrev_rec.CATEGORY_SET_ID,
3321: l_itemrev_rec.last_update_date
3322: );
3323:
3324: INSERT INTO EDW_ITEM_ITEMREV_LSTG(
3325: ITEM_REVISION_PK,
3326: ITEM_ORG_FK,
3327: NAME,
3328: CATEGORY_ID,

Line 3554: INSERT INTO EDW_ITEM_ITEMREV_LSTG(

3550: edw_log.put_line(' ');
3551:
3552: edw_log.put_line('Pushing Product Category to lower level EDW_ITEM_ITEMREV');
3553:
3554: INSERT INTO EDW_ITEM_ITEMREV_LSTG(
3555: ITEM_REVISION_PK,
3556: ITEM_ORG_FK,
3557: NAME,
3558: INSTANCE,

Line 3722: INSERT INTO EDW_ITEM_ITEMREV_LSTG(

3718: edw_log.put_line(' ');
3719:
3720: edw_log.put_line('Pushing Product Category to lower level EDW_ITEM_ITEMREV');
3721:
3722: INSERT INTO EDW_ITEM_ITEMREV_LSTG(
3723: ITEM_REVISION_PK,
3724: ITEM_ORG_FK,
3725: INSTANCE,
3726: NAME,

Line 3817: INSERT INTO EDW_ITEM_ITEMREV_LSTG(

3813: edw_log.put_line(' ');
3814:
3815: edw_log.put_line('Pushing Product Group to lower level EDW_ITEM_ITEMREV');
3816:
3817: INSERT INTO EDW_ITEM_ITEMREV_LSTG(
3818: ITEM_REVISION_PK,
3819: ITEM_ORG_FK,
3820: NAME,
3821: INSTANCE,