APPS.POA_EDW_PO_DIST_F_C dependencies on POA_EDW_PO_DIST_FSTG

Line 59: FROM POA_EDW_PO_DIST_FSTG fstg

55: IS
56: BEGIN
57: INSERT INTO poa_edw_po_dist_inc(primary_key,batch_id)
58: SELECT DESTRIBUTION_ID,0
59: FROM POA_EDW_PO_DIST_FSTG fstg
60: WHERE fstg.COLLECTION_STATUS = 'RATE NOT AVAILABLE'
61: OR fstg.COLLECTION_STATUS = 'INVALID CURRENCY';
62:
63: IF (sql%rowcount > 0) THEN

Line 82: -- DELETE FROM POA_EDW_PO_DIST_FSTG

78: -- collection status of either rate not available or invalid currency.
79: PROCEDURE DELETE_STG_MISSING_RATES
80: IS
81: BEGIN
82: -- DELETE FROM POA_EDW_PO_DIST_FSTG
83: -- WHERE COLLECTION_STATUS = 'RATE NOT AVAILABLE'
84: -- OR COLLECTION_STATUS = 'INVALID CURRENCY'
85: -- AND INSTANCE_FK = (SELECT INSTANCE_CODE
86: -- FROM EDW_LOCAL_INSTANCE);

Line 172: Insert Into POA_EDW_PO_DIST_FSTG(

168: -- get minimum accountable unit of the warehouse currency;
169:
170: l_mau := nvl( edw_currency.get_mau, 0.01 );
171:
172: Insert Into POA_EDW_PO_DIST_FSTG(
173: CHECK_CUT_DATE_FK,
174: INV_RECEIVED_DATE_FK,
175: INV_CREATION_DATE_FK,
176: GOODS_RECEIVED_DATE_FK,

Line 655: l_staging_table Varchar2(30) :='POA_EDW_PO_DIST_FSTG';

651: p_to_date IN Varchar2) IS
652:
653:
654: l_fact_name Varchar2(30) :='POA_EDW_PO_DIST_F';
655: l_staging_table Varchar2(30) :='POA_EDW_PO_DIST_FSTG';
656: l_exception_msg Varchar2(2000):=Null;
657: l_from_date Date:=Null;
658: l_to_date Date:=Null;
659: l_seq_id1 NUMBER := -1;

Line 677: FROM POA_EDW_PO_DIST_FSTG fstg,

673: 'User',gsob.currency_code,
674: NVL(poh.currency_code,
675: gsob.currency_code)) From_Currency,
676: fstg.Collection_Status
677: FROM POA_EDW_PO_DIST_FSTG fstg,
678: po_distributions_all pod,
679: po_headers_all poh,
680: gl_sets_of_books gsob
681: WHERE (fstg.COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR