DBA Data[Home] [Help]

APPS.FII_AP_INV_ACTIVITY_DETAIL dependencies on STANDARD

Line 1426: WHEN 'FII_AP_STANDARD_INV_ENT_DTL' THEN -- 10th, Standard Invoices Entered Detail

1422: &ORDER_BY_CLAUSE
1423: ';
1424:
1425:
1426: WHEN 'FII_AP_STANDARD_INV_ENT_DTL' THEN -- 10th, Standard Invoices Entered Detail
1427: sqlstmt := '
1428: SELECT
1429: h.FII_MEASURE1 FII_MEASURE1,
1430: h.FII_MEASURE2 FII_MEASURE2,

Line 1527: WHERE f.invoice_type = ''STANDARD''

1523: WHERE 1 =1
1524: '||l_org_where||' '||l_sup_where||'
1525: GROUP BY invoice_id
1526: ) hold1
1527: WHERE f.invoice_type = ''STANDARD''
1528: '||l_org_where||' '||l_sup_where||'
1529: AND f.cancel_flag = ''N'' /*Added code for bug. no.3084280 */
1530: AND f.entered_date <= &BIS_CURRENT_ASOF_DATE
1531: AND f.entered_date >= :PERIOD_START