DBA Data[Home] [Help]

APPS.FII_AP_INV_ACTIVITY dependencies on STANDARD

Line 362: l_url_2 := 'pFunctionName=FII_AP_STANDARD_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_STANDARD_INV_ENT_DTL';

358: l_url_7 := '';
359: l_url_8 := '';
360: ELSIF l_viewby_dim = 'SUPPLIER+POA_SUPPLIERS' THEN
361: l_url_1 := 'pFunctionName=FII_AP_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_INV_ENT_DTL';
362: l_url_2 := 'pFunctionName=FII_AP_STANDARD_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_STANDARD_INV_ENT_DTL';
363: l_url_3 := 'pFunctionName=FII_AP_WITHHOLDING_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_WITHHOLDING_INV_ENT_DTL';
364: l_url_4 := 'pFunctionName=FII_AP_PREPAYMENT_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_PREPAYMENT_INV_ENT_DTL';
365: l_url_5 := 'pFunctionName=FII_AP_CREDIT_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_CREDIT_INV_ENT_DTL';
366: l_url_6 := 'pFunctionName=FII_AP_DEBIT_INV_ENT_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&FII_REPORT_SOURCE=FII_AP_DEBIT_INV_ENT_DTL';

Line 381: | FII_MEASURE7 Standard

377: | FII_MEASURE3 Change
378: | FII_MEASURE4 Invoices Entered
379: | FII_MEASURE5 Prior Invoices Entered
380: | FII_MEASURE6 Change
381: | FII_MEASURE7 Standard
382: | FII_MEASURE8 Withholding
383: | FII_MEASURE9 Prepayment
384: | FII_MEASURE10 Credit
385: | FII_MEASURE11 Debit

Line 392: | FII_MEASURE19 Grand Total(standard)

388: | FII_MEASURE15 Grand Total(invoice amount entered)
389: | FII_MEASURE16 Grand Total(prior invoice amount entered)
390: | FII_MEASURE17 Grand Total(invoice count entered)
391: | FII_MEASURE18 Grand Total(prior invoice count entered)
392: | FII_MEASURE19 Grand Total(standard)
393: | FII_MEASURE20 Grand Total(withholding)
394: | FII_MEASURE21 Grand Total(prepayment)
395: | FII_MEASURE22 Grand Total(credit)
396: | FII_MEASURE23 Grand Total(debit)

Line 485: THEN f.stANDard_count ELSE 0 END) FII_MEASURE7,

481: THEN f.invoice_count_entered ELSE 0 END) FII_MEASURE4,
482: SUM(CASE WHEN cal.report_date = &BIS_PREVIOUS_ASOF_DATE
483: THEN f.invoice_count_entered ELSE 0 END) FII_MEASURE5,
484: SUM(CASE WHEN cal.report_date = &BIS_CURRENT_ASOF_DATE
485: THEN f.stANDard_count ELSE 0 END) FII_MEASURE7,
486: SUM(CASE WHEN cal.report_date = &BIS_CURRENT_ASOF_DATE
487: THEN f.withholding_count ELSE 0 END) FII_MEASURE8,
488: SUM(CASE WHEN cal.report_date = &BIS_CURRENT_ASOF_DATE
489: THEN f.prepayment_count ELSE 0 END) FII_MEASURE9,