APPS.EDW_UNSPSC_M_C dependencies on POA_DNB_ITEMS

Line 119: Update POA_DNB_ITEMS poa

115: set Commodity = UNSPSC,
116: Commodity_Description = UNSPSC_DESCRIPTION
117: where (Commodity IS NULL);
118:
119: Update POA_DNB_ITEMS poa
120: set (Item_PK, Item_Name, Function, DNB_Update_Date) =
121: (select Item_PK, Item_Name, UNSPSC || '-' || Function,
122: sysdate from POA_UNSPSC_INTERFACE dnb
123: where poa.Item_PK = dnb.Item_PK)

Line 129: insert into POA_DNB_ITEMS poa

125: (select Item_PK from POA_UNSPSC_INTERFACE dnb
126: where ((poa.Item_PK = dnb.Item_PK) and
127: (poa.Function <> dnb.Function)));
128:
129: insert into POA_DNB_ITEMS poa
130: (Item_PK, Item_Name, Function, DNB_Update_Date)
131: (select Item_PK, Item_Name, UNSPSC || '-' || Function,
132: sysdate from POA_UNSPSC_INTERFACE dnb
133: where dnb.Item_PK NOT IN (select Item_PK

Line 134: from POA_DNB_ITEMS));

130: (Item_PK, Item_Name, Function, DNB_Update_Date)
131: (select Item_PK, Item_Name, UNSPSC || '-' || Function,
132: sysdate from POA_UNSPSC_INTERFACE dnb
133: where dnb.Item_PK NOT IN (select Item_PK
134: from POA_DNB_ITEMS));
135:
136: END Push_EDW_DNB_POA_ITEMS;
137:
138: Procedure Push_EDW_UNSPSC_CLASS_LSTG(p_from_date IN date, p_to_date IN DATE) IS

Line 288: from POA_DNB_ITEMS poa

284:
285: Update POA_UNSPSC_INTERFACE
286: set Update_Fact_Flag = 'Y'
287: where Item_PK IN (select Item_PK
288: from POA_DNB_ITEMS poa
289: where poa.DNB_Update_Date between
290: l_date1 and l_date2);
291:
292:

Line 315: POA_DNB_ITEMS poa

311: sysdate,
312: 'READY',
313: dnb.Update_Fact_Flag
314: from POA_UNSPSC_INTERFACE dnb,
315: POA_DNB_ITEMS poa
316: where (dnb.Item_PK = poa.Item_PK);
317:
318: l_rows_inserted := sql%rowcount;
319: EDW_UNSPSC_M_C.g_row_count := EDW_UNSPSC_M_C.g_row_count + l_rows_inserted ;