APPS.POA_EDW_ALINES_F_C dependencies on POA_EDW_ALINES_FSTG

Line 44: FROM POA_EDW_ALINES_FSTG

40: IS
41: BEGIN
42: INSERT INTO poa_edw_alines_inc(primary_key)
43: SELECT po_line_id
44: FROM POA_EDW_ALINES_FSTG
45: where COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR
46: COLLECTION_STATUS = 'INVALID CURRENCY';
47:
48: IF (sql%rowcount > 0) THEN

Line 68: DELETE FROM POA_EDW_ALINES_FSTG

64: -- collection status of either rate not available or invalid currency.
65: PROCEDURE DELETE_STG_MISSING_RATES
66: IS
67: BEGIN
68: DELETE FROM POA_EDW_ALINES_FSTG
69: WHERE COLLECTION_STATUS = 'RATE NOT AVAILABLE'
70: OR COLLECTION_STATUS = 'INVALID CURRENCY'
71: AND INSTANCE_FK = (SELECT INSTANCE_CODE
72: FROM EDW_LOCAL_INSTANCE);

Line 101: Insert Into POA_EDW_ALINES_FSTG (

97: edw_log.put_line(' ');
98: edw_log.put_line('Pushing data to local staging table...');
99:
100: l_temp_date := sysdate;
101: Insert Into POA_EDW_ALINES_FSTG (
102: DUNS_FK,
103: UNSPSC_FK,
104: SIC_CODE_FK,
105: ACCPT_DUE_DATE_FK,

Line 433: l_staging_table Varchar2(30) := 'POA_EDW_ALINES_FSTG';

429: p_from_date IN Varchar2,
430: p_to_date IN Varchar2) IS
431:
432: l_fact_name Varchar2(30) := 'POA_EDW_ALINES_F';
433: l_staging_table Varchar2(30) := 'POA_EDW_ALINES_FSTG';
434:
435:
436: -- -------------------------------------------
437: -- Put any additional developer variables here

Line 465: FROM POA_EDW_ALINES_FSTG fstg,

461: 'User',gsob.currency_code,
462: NVL(poh.currency_code,
463: gsob.currency_code)) From_Currency,
464: fstg.Collection_Status
465: FROM POA_EDW_ALINES_FSTG fstg,
466: PO_HEADERS_ALL POH,
467: po_lines_all pol,
468: GL_SETS_OF_BOOKS GSOB,
469: FINANCIALS_SYSTEM_PARAMS_ALL FSP