eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_SD_BATCH_PVT dependencies on FND_DSQL

Line 1397: FND_DSQL.init;

1393: l_end_date := p_end_date;
1394: l_period := p_period;
1395: l_ozf_gl_entries := fnd_profile.value('OZF_ORDER_GLPOST_PHASE');
1396:
1397: FND_DSQL.init;
1398:
1399: FND_DSQL.add_text('SELECT ');
1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');

Line 1399: FND_DSQL.add_text('SELECT ');

1395: l_ozf_gl_entries := fnd_profile.value('OZF_ORDER_GLPOST_PHASE');
1396:
1397: FND_DSQL.init;
1398:
1399: FND_DSQL.add_text('SELECT ');
1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');

Line 1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');

1396:
1397: FND_DSQL.init;
1398:
1399: FND_DSQL.add_text('SELECT ');
1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');

Line 1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');

1397: FND_DSQL.init;
1398:
1399: FND_DSQL.add_text('SELECT ');
1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');
1405: FND_DSQL.add_text('HZCA.PARTY_ID, ');

Line 1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');

1398:
1399: FND_DSQL.add_text('SELECT ');
1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');
1405: FND_DSQL.add_text('HZCA.PARTY_ID, ');
1406: FND_DSQL.add_text('OEH.SOLD_TO_CONTACT_ID, ');

Line 1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');

1399: FND_DSQL.add_text('SELECT ');
1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');
1405: FND_DSQL.add_text('HZCA.PARTY_ID, ');
1406: FND_DSQL.add_text('OEH.SOLD_TO_CONTACT_ID, ');
1407: FND_DSQL.add_text('OEH.SOLD_TO_SITE_USE_ID, ');

Line 1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');

1400: FND_DSQL.add_text('OZF_SD_BATCH_LINES_ALL_S.NEXTVAL , ');
1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');
1405: FND_DSQL.add_text('HZCA.PARTY_ID, ');
1406: FND_DSQL.add_text('OEH.SOLD_TO_CONTACT_ID, ');
1407: FND_DSQL.add_text('OEH.SOLD_TO_SITE_USE_ID, ');
1408:

Line 1405: FND_DSQL.add_text('HZCA.PARTY_ID, ');

1401: FND_DSQL.add_text('FU.UTILIZATION_ID, ');
1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');
1405: FND_DSQL.add_text('HZCA.PARTY_ID, ');
1406: FND_DSQL.add_text('OEH.SOLD_TO_CONTACT_ID, ');
1407: FND_DSQL.add_text('OEH.SOLD_TO_SITE_USE_ID, ');
1408:
1409: FND_DSQL.add_text('OEL.END_CUSTOMER_ID, ');

Line 1406: FND_DSQL.add_text('OEH.SOLD_TO_CONTACT_ID, ');

1402: FND_DSQL.add_text('RH.AUTHORIZATION_NUMBER, ');
1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');
1405: FND_DSQL.add_text('HZCA.PARTY_ID, ');
1406: FND_DSQL.add_text('OEH.SOLD_TO_CONTACT_ID, ');
1407: FND_DSQL.add_text('OEH.SOLD_TO_SITE_USE_ID, ');
1408:
1409: FND_DSQL.add_text('OEL.END_CUSTOMER_ID, ');
1410: FND_DSQL.add_text('OEL.END_CUSTOMER_CONTACT_ID, ');

Line 1407: FND_DSQL.add_text('OEH.SOLD_TO_SITE_USE_ID, ');

1403: FND_DSQL.add_text('OEL.SHIP_TO_ORG_ID, ');
1404: FND_DSQL.add_text('OEL.SHIP_TO_CONTACT_ID, ');
1405: FND_DSQL.add_text('HZCA.PARTY_ID, ');
1406: FND_DSQL.add_text('OEH.SOLD_TO_CONTACT_ID, ');
1407: FND_DSQL.add_text('OEH.SOLD_TO_SITE_USE_ID, ');
1408:
1409: FND_DSQL.add_text('OEL.END_CUSTOMER_ID, ');
1410: FND_DSQL.add_text('OEL.END_CUSTOMER_CONTACT_ID, ');
1411:

Line 1409: FND_DSQL.add_text('OEL.END_CUSTOMER_ID, ');

1405: FND_DSQL.add_text('HZCA.PARTY_ID, ');
1406: FND_DSQL.add_text('OEH.SOLD_TO_CONTACT_ID, ');
1407: FND_DSQL.add_text('OEH.SOLD_TO_SITE_USE_ID, ');
1408:
1409: FND_DSQL.add_text('OEL.END_CUSTOMER_ID, ');
1410: FND_DSQL.add_text('OEL.END_CUSTOMER_CONTACT_ID, ');
1411:
1412: FND_DSQL.add_text('OEL.HEADER_ID, ');
1413: FND_DSQL.add_text('OEL.LINE_ID, ');

Line 1410: FND_DSQL.add_text('OEL.END_CUSTOMER_CONTACT_ID, ');

1406: FND_DSQL.add_text('OEH.SOLD_TO_CONTACT_ID, ');
1407: FND_DSQL.add_text('OEH.SOLD_TO_SITE_USE_ID, ');
1408:
1409: FND_DSQL.add_text('OEL.END_CUSTOMER_ID, ');
1410: FND_DSQL.add_text('OEL.END_CUSTOMER_CONTACT_ID, ');
1411:
1412: FND_DSQL.add_text('OEL.HEADER_ID, ');
1413: FND_DSQL.add_text('OEL.LINE_ID, ');
1414:

Line 1412: FND_DSQL.add_text('OEL.HEADER_ID, ');

1408:
1409: FND_DSQL.add_text('OEL.END_CUSTOMER_ID, ');
1410: FND_DSQL.add_text('OEL.END_CUSTOMER_CONTACT_ID, ');
1411:
1412: FND_DSQL.add_text('OEL.HEADER_ID, ');
1413: FND_DSQL.add_text('OEL.LINE_ID, ');
1414:
1415:
1416: FND_DSQL.add_text('(SELECT CTLA.CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX_LINES_ALL CTLA WHERE CTLA.INTERFACE_LINE_ATTRIBUTE1 = TO_CHAR(OEH.ORDER_NUMBER)

Line 1413: FND_DSQL.add_text('OEL.LINE_ID, ');

1409: FND_DSQL.add_text('OEL.END_CUSTOMER_ID, ');
1410: FND_DSQL.add_text('OEL.END_CUSTOMER_CONTACT_ID, ');
1411:
1412: FND_DSQL.add_text('OEL.HEADER_ID, ');
1413: FND_DSQL.add_text('OEL.LINE_ID, ');
1414:
1415:
1416: FND_DSQL.add_text('(SELECT CTLA.CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX_LINES_ALL CTLA WHERE CTLA.INTERFACE_LINE_ATTRIBUTE1 = TO_CHAR(OEH.ORDER_NUMBER)
1417: AND CTLA.SALES_ORDER_LINE = TO_CHAR(OEL.LINE_NUMBER)

Line 1416: FND_DSQL.add_text('(SELECT CTLA.CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX_LINES_ALL CTLA WHERE CTLA.INTERFACE_LINE_ATTRIBUTE1 = TO_CHAR(OEH.ORDER_NUMBER)

1412: FND_DSQL.add_text('OEL.HEADER_ID, ');
1413: FND_DSQL.add_text('OEL.LINE_ID, ');
1414:
1415:
1416: FND_DSQL.add_text('(SELECT CTLA.CUSTOMER_TRX_ID FROM RA_CUSTOMER_TRX_LINES_ALL CTLA WHERE CTLA.INTERFACE_LINE_ATTRIBUTE1 = TO_CHAR(OEH.ORDER_NUMBER)
1417: AND CTLA.SALES_ORDER_LINE = TO_CHAR(OEL.LINE_NUMBER)
1418: AND CTLA.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(OEL.LINE_ID)
1419: AND CTLA.LINE_TYPE = ''LINE''
1420: AND ROWNUM = 1) TRX_NUMBER,');

Line 1422: FND_DSQL.add_text('(SELECT CTLA.SALES_ORDER_LINE FROM RA_CUSTOMER_TRX_LINES_ALL CTLA WHERE CTLA.INTERFACE_LINE_ATTRIBUTE1 = TO_CHAR(OEH.ORDER_NUMBER)

1418: AND CTLA.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(OEL.LINE_ID)
1419: AND CTLA.LINE_TYPE = ''LINE''
1420: AND ROWNUM = 1) TRX_NUMBER,');
1421:
1422: FND_DSQL.add_text('(SELECT CTLA.SALES_ORDER_LINE FROM RA_CUSTOMER_TRX_LINES_ALL CTLA WHERE CTLA.INTERFACE_LINE_ATTRIBUTE1 = TO_CHAR(OEH.ORDER_NUMBER)
1423: AND CTLA.SALES_ORDER_LINE = TO_CHAR(OEL.LINE_NUMBER)
1424: AND CTLA.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(OEL.LINE_ID)
1425: AND CTLA.LINE_TYPE = ''LINE''
1426: AND ROWNUM = 1) LINE_NUMBER, ');

Line 1429: FND_DSQL.add_text('OEH.TRANSACTIONAL_CURR_CODE, ');

1425: AND CTLA.LINE_TYPE = ''LINE''
1426: AND ROWNUM = 1) LINE_NUMBER, ');
1427:
1428:
1429: FND_DSQL.add_text('OEH.TRANSACTIONAL_CURR_CODE, ');
1430:
1431: -- resale price = order.unit_selling price - ( fu.plan_currency_amt_remaining / order qty (based on profile))
1432: IF l_ozf_gl_entries = 'SHIPPED' then
1433: FND_DSQL.add_text('OEL.UNIT_SELLING_PRICE-(FU.PLAN_CURR_AMOUNT_REMAINING / NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1)))), ');

Line 1433: FND_DSQL.add_text('OEL.UNIT_SELLING_PRICE-(FU.PLAN_CURR_AMOUNT_REMAINING / NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1)))), ');

1429: FND_DSQL.add_text('OEH.TRANSACTIONAL_CURR_CODE, ');
1430:
1431: -- resale price = order.unit_selling price - ( fu.plan_currency_amt_remaining / order qty (based on profile))
1432: IF l_ozf_gl_entries = 'SHIPPED' then
1433: FND_DSQL.add_text('OEL.UNIT_SELLING_PRICE-(FU.PLAN_CURR_AMOUNT_REMAINING / NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1)))), ');
1434: END IF;
1435:
1436: IF l_ozf_gl_entries = 'INVOICED' THEN
1437: FND_DSQL.add_text('OEL.UNIT_SELLING_PRICE-(FU.PLAN_CURR_AMOUNT_REMAINING / NVL(oel.invoiced_quantity, NVL(oel.shipped_quantity, NVL(oel.ordered_quantity, 1)))), ');

Line 1437: FND_DSQL.add_text('OEL.UNIT_SELLING_PRICE-(FU.PLAN_CURR_AMOUNT_REMAINING / NVL(oel.invoiced_quantity, NVL(oel.shipped_quantity, NVL(oel.ordered_quantity, 1)))), ');

1433: FND_DSQL.add_text('OEL.UNIT_SELLING_PRICE-(FU.PLAN_CURR_AMOUNT_REMAINING / NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1)))), ');
1434: END IF;
1435:
1436: IF l_ozf_gl_entries = 'INVOICED' THEN
1437: FND_DSQL.add_text('OEL.UNIT_SELLING_PRICE-(FU.PLAN_CURR_AMOUNT_REMAINING / NVL(oel.invoiced_quantity, NVL(oel.shipped_quantity, NVL(oel.ordered_quantity, 1)))), ');
1438: END IF;
1439:
1440: FND_DSQL.add_text('RH.REQUEST_CURRENCY_CODE, ');
1441: FND_DSQL.add_text('OEL.UNIT_LIST_PRICE, ');

Line 1440: FND_DSQL.add_text('RH.REQUEST_CURRENCY_CODE, ');

1436: IF l_ozf_gl_entries = 'INVOICED' THEN
1437: FND_DSQL.add_text('OEL.UNIT_SELLING_PRICE-(FU.PLAN_CURR_AMOUNT_REMAINING / NVL(oel.invoiced_quantity, NVL(oel.shipped_quantity, NVL(oel.ordered_quantity, 1)))), ');
1438: END IF;
1439:
1440: FND_DSQL.add_text('RH.REQUEST_CURRENCY_CODE, ');
1441: FND_DSQL.add_text('OEL.UNIT_LIST_PRICE, ');
1442: FND_DSQL.add_text('RH.REQUEST_CURRENCY_CODE, ');
1443:
1444: -- Call CONV_DISC_TO_OFFER_CURR_AMOUNT where

Line 1441: FND_DSQL.add_text('OEL.UNIT_LIST_PRICE, ');

1437: FND_DSQL.add_text('OEL.UNIT_SELLING_PRICE-(FU.PLAN_CURR_AMOUNT_REMAINING / NVL(oel.invoiced_quantity, NVL(oel.shipped_quantity, NVL(oel.ordered_quantity, 1)))), ');
1438: END IF;
1439:
1440: FND_DSQL.add_text('RH.REQUEST_CURRENCY_CODE, ');
1441: FND_DSQL.add_text('OEL.UNIT_LIST_PRICE, ');
1442: FND_DSQL.add_text('RH.REQUEST_CURRENCY_CODE, ');
1443:
1444: -- Call CONV_DISC_TO_OFFER_CURR_AMOUNT where
1445: -- To Currency OFRS.TRANSACTION_CURRENCY_CODE

Line 1442: FND_DSQL.add_text('RH.REQUEST_CURRENCY_CODE, ');

1438: END IF;
1439:
1440: FND_DSQL.add_text('RH.REQUEST_CURRENCY_CODE, ');
1441: FND_DSQL.add_text('OEL.UNIT_LIST_PRICE, ');
1442: FND_DSQL.add_text('RH.REQUEST_CURRENCY_CODE, ');
1443:
1444: -- Call CONV_DISC_TO_OFFER_CURR_AMOUNT where
1445: -- To Currency OFRS.TRANSACTION_CURRENCY_CODE
1446: -- From Currency RL. APPROVED_DISCOUNT_CURRENCY

Line 1452: FND_DSQL.add_text('decode (rl.APPROVED_DISCOUNT_TYPE,

1448: -- Batch ID p_batch_id
1449:
1450: l_func_call_string := 'OZF_SD_BATCH_PVT.CONV_DISC_TO_OFFER_CURR_AMOUNT(OFRS.TRANSACTION_CURRENCY_CODE,RL. APPROVED_DISCOUNT_CURRENCY, RL.APPROVED_DISCOUNT_VALUE, ' || p_batch_id || ' )';
1451:
1452: FND_DSQL.add_text('decode (rl.APPROVED_DISCOUNT_TYPE,
1453: ''%'', (OEL.UNIT_LIST_PRICE * (1 - RL.APPROVED_DISCOUNT_VALUE/100)),
1454: ''AMT'', (OEL.UNIT_LIST_PRICE - ' || l_func_call_string || '),
1455: ''NEWPRICE'', '|| l_func_call_string || ', ' ||
1456: l_func_call_string || ') APPROVED_DISCOUNT_VALUE, ');

Line 1458: FND_DSQL.add_text('FU.PLAN_CURR_AMOUNT_REMAINING, ');

1454: ''AMT'', (OEL.UNIT_LIST_PRICE - ' || l_func_call_string || '),
1455: ''NEWPRICE'', '|| l_func_call_string || ', ' ||
1456: l_func_call_string || ') APPROVED_DISCOUNT_VALUE, ');
1457:
1458: FND_DSQL.add_text('FU.PLAN_CURR_AMOUNT_REMAINING, ');
1459: FND_DSQL.add_text('OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(FU.UTILIZATION_ID,' );
1460: FND_DSQL.add_bind(''||p_batch_currency||'' );
1461: FND_DSQL.add_text(',');
1462: FND_DSQL.add_bind(p_batch_id);

Line 1459: FND_DSQL.add_text('OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(FU.UTILIZATION_ID,' );

1455: ''NEWPRICE'', '|| l_func_call_string || ', ' ||
1456: l_func_call_string || ') APPROVED_DISCOUNT_VALUE, ');
1457:
1458: FND_DSQL.add_text('FU.PLAN_CURR_AMOUNT_REMAINING, ');
1459: FND_DSQL.add_text('OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(FU.UTILIZATION_ID,' );
1460: FND_DSQL.add_bind(''||p_batch_currency||'' );
1461: FND_DSQL.add_text(',');
1462: FND_DSQL.add_bind(p_batch_id);
1463: FND_DSQL.add_text('),');

Line 1460: FND_DSQL.add_bind(''||p_batch_currency||'' );

1456: l_func_call_string || ') APPROVED_DISCOUNT_VALUE, ');
1457:
1458: FND_DSQL.add_text('FU.PLAN_CURR_AMOUNT_REMAINING, ');
1459: FND_DSQL.add_text('OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(FU.UTILIZATION_ID,' );
1460: FND_DSQL.add_bind(''||p_batch_currency||'' );
1461: FND_DSQL.add_text(',');
1462: FND_DSQL.add_bind(p_batch_id);
1463: FND_DSQL.add_text('),');
1464:

Line 1461: FND_DSQL.add_text(',');

1457:
1458: FND_DSQL.add_text('FU.PLAN_CURR_AMOUNT_REMAINING, ');
1459: FND_DSQL.add_text('OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(FU.UTILIZATION_ID,' );
1460: FND_DSQL.add_bind(''||p_batch_currency||'' );
1461: FND_DSQL.add_text(',');
1462: FND_DSQL.add_bind(p_batch_id);
1463: FND_DSQL.add_text('),');
1464:
1465: FND_DSQL.add_text('FU.PRODUCT_ID, ');

Line 1462: FND_DSQL.add_bind(p_batch_id);

1458: FND_DSQL.add_text('FU.PLAN_CURR_AMOUNT_REMAINING, ');
1459: FND_DSQL.add_text('OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(FU.UTILIZATION_ID,' );
1460: FND_DSQL.add_bind(''||p_batch_currency||'' );
1461: FND_DSQL.add_text(',');
1462: FND_DSQL.add_bind(p_batch_id);
1463: FND_DSQL.add_text('),');
1464:
1465: FND_DSQL.add_text('FU.PRODUCT_ID, ');
1466:

Line 1463: FND_DSQL.add_text('),');

1459: FND_DSQL.add_text('OZF_SD_BATCH_PVT.GET_BATCH_CURRENCY_AMOUNT(FU.UTILIZATION_ID,' );
1460: FND_DSQL.add_bind(''||p_batch_currency||'' );
1461: FND_DSQL.add_text(',');
1462: FND_DSQL.add_bind(p_batch_id);
1463: FND_DSQL.add_text('),');
1464:
1465: FND_DSQL.add_text('FU.PRODUCT_ID, ');
1466:
1467: FND_DSQL.add_text('NVL(OEL.SHIPPING_QUANTITY_UOM, OEL.ORDER_QUANTITY_UOM), ');

Line 1465: FND_DSQL.add_text('FU.PRODUCT_ID, ');

1461: FND_DSQL.add_text(',');
1462: FND_DSQL.add_bind(p_batch_id);
1463: FND_DSQL.add_text('),');
1464:
1465: FND_DSQL.add_text('FU.PRODUCT_ID, ');
1466:
1467: FND_DSQL.add_text('NVL(OEL.SHIPPING_QUANTITY_UOM, OEL.ORDER_QUANTITY_UOM), ');
1468:
1469: IF l_ozf_gl_entries is null then

Line 1467: FND_DSQL.add_text('NVL(OEL.SHIPPING_QUANTITY_UOM, OEL.ORDER_QUANTITY_UOM), ');

1463: FND_DSQL.add_text('),');
1464:
1465: FND_DSQL.add_text('FU.PRODUCT_ID, ');
1466:
1467: FND_DSQL.add_text('NVL(OEL.SHIPPING_QUANTITY_UOM, OEL.ORDER_QUANTITY_UOM), ');
1468:
1469: IF l_ozf_gl_entries is null then
1470: l_ozf_gl_entries := 'SHIPPED';
1471: END IF;

Line 1474: FND_DSQL.add_text('NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1))), ');

1470: l_ozf_gl_entries := 'SHIPPED';
1471: END IF;
1472:
1473: IF l_ozf_gl_entries = 'SHIPPED' THEN
1474: FND_DSQL.add_text('NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1))), ');
1475: END IF;
1476:
1477: IF l_ozf_gl_entries = 'INVOICED' THEN
1478: FND_DSQL.add_text('NVL(oel.invoiced_quantity, NVL(oel.shipped_quantity, NVL(oel.ordered_quantity, 1))), ');

Line 1478: FND_DSQL.add_text('NVL(oel.invoiced_quantity, NVL(oel.shipped_quantity, NVL(oel.ordered_quantity, 1))), ');

1474: FND_DSQL.add_text('NVL(oel.shipped_quantity, NVL(oel.invoiced_quantity, NVL(oel.ordered_quantity, 1))), ');
1475: END IF;
1476:
1477: IF l_ozf_gl_entries = 'INVOICED' THEN
1478: FND_DSQL.add_text('NVL(oel.invoiced_quantity, NVL(oel.shipped_quantity, NVL(oel.ordered_quantity, 1))), ');
1479: END IF;
1480:
1481: FND_DSQL.add_text('OEH.ordered_date, ');
1482:

Line 1481: FND_DSQL.add_text('OEH.ordered_date, ');

1477: IF l_ozf_gl_entries = 'INVOICED' THEN
1478: FND_DSQL.add_text('NVL(oel.invoiced_quantity, NVL(oel.shipped_quantity, NVL(oel.ordered_quantity, 1))), ');
1479: END IF;
1480:
1481: FND_DSQL.add_text('OEH.ordered_date, ');
1482:
1483:
1484: FND_DSQL.add_text('OFRS.TRANSACTION_CURRENCY_CODE, ');
1485: FND_DSQL.add_text('FU.ACCTD_AMOUNT_REMAINING, ');

Line 1484: FND_DSQL.add_text('OFRS.TRANSACTION_CURRENCY_CODE, ');

1480:
1481: FND_DSQL.add_text('OEH.ordered_date, ');
1482:
1483:
1484: FND_DSQL.add_text('OFRS.TRANSACTION_CURRENCY_CODE, ');
1485: FND_DSQL.add_text('FU.ACCTD_AMOUNT_REMAINING, ');
1486: FND_DSQL.add_text('FU.UNIV_CURR_AMOUNT_REMAINING, ');
1487: FND_DSQL.add_text('FU.AMOUNT_REMAINING, ');
1488: FND_DSQL.add_text('RL.ORG_ID '); -- Inventory Org ID

Line 1485: FND_DSQL.add_text('FU.ACCTD_AMOUNT_REMAINING, ');

1481: FND_DSQL.add_text('OEH.ordered_date, ');
1482:
1483:
1484: FND_DSQL.add_text('OFRS.TRANSACTION_CURRENCY_CODE, ');
1485: FND_DSQL.add_text('FU.ACCTD_AMOUNT_REMAINING, ');
1486: FND_DSQL.add_text('FU.UNIV_CURR_AMOUNT_REMAINING, ');
1487: FND_DSQL.add_text('FU.AMOUNT_REMAINING, ');
1488: FND_DSQL.add_text('RL.ORG_ID '); -- Inventory Org ID
1489:

Line 1486: FND_DSQL.add_text('FU.UNIV_CURR_AMOUNT_REMAINING, ');

1482:
1483:
1484: FND_DSQL.add_text('OFRS.TRANSACTION_CURRENCY_CODE, ');
1485: FND_DSQL.add_text('FU.ACCTD_AMOUNT_REMAINING, ');
1486: FND_DSQL.add_text('FU.UNIV_CURR_AMOUNT_REMAINING, ');
1487: FND_DSQL.add_text('FU.AMOUNT_REMAINING, ');
1488: FND_DSQL.add_text('RL.ORG_ID '); -- Inventory Org ID
1489:
1490: --BEGIN FROM CLAUSE

Line 1487: FND_DSQL.add_text('FU.AMOUNT_REMAINING, ');

1483:
1484: FND_DSQL.add_text('OFRS.TRANSACTION_CURRENCY_CODE, ');
1485: FND_DSQL.add_text('FU.ACCTD_AMOUNT_REMAINING, ');
1486: FND_DSQL.add_text('FU.UNIV_CURR_AMOUNT_REMAINING, ');
1487: FND_DSQL.add_text('FU.AMOUNT_REMAINING, ');
1488: FND_DSQL.add_text('RL.ORG_ID '); -- Inventory Org ID
1489:
1490: --BEGIN FROM CLAUSE
1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');

Line 1488: FND_DSQL.add_text('RL.ORG_ID '); -- Inventory Org ID

1484: FND_DSQL.add_text('OFRS.TRANSACTION_CURRENCY_CODE, ');
1485: FND_DSQL.add_text('FU.ACCTD_AMOUNT_REMAINING, ');
1486: FND_DSQL.add_text('FU.UNIV_CURR_AMOUNT_REMAINING, ');
1487: FND_DSQL.add_text('FU.AMOUNT_REMAINING, ');
1488: FND_DSQL.add_text('RL.ORG_ID '); -- Inventory Org ID
1489:
1490: --BEGIN FROM CLAUSE
1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');
1492: FND_DSQL.add_text('OE_ORDER_HEADERS_ALL OEH, ');

Line 1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');

1487: FND_DSQL.add_text('FU.AMOUNT_REMAINING, ');
1488: FND_DSQL.add_text('RL.ORG_ID '); -- Inventory Org ID
1489:
1490: --BEGIN FROM CLAUSE
1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');
1492: FND_DSQL.add_text('OE_ORDER_HEADERS_ALL OEH, ');
1493: FND_DSQL.add_text('OE_ORDER_LINES_ALL OEL, ');
1494: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');

Line 1492: FND_DSQL.add_text('OE_ORDER_HEADERS_ALL OEH, ');

1488: FND_DSQL.add_text('RL.ORG_ID '); -- Inventory Org ID
1489:
1490: --BEGIN FROM CLAUSE
1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');
1492: FND_DSQL.add_text('OE_ORDER_HEADERS_ALL OEH, ');
1493: FND_DSQL.add_text('OE_ORDER_LINES_ALL OEL, ');
1494: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');
1496:

Line 1493: FND_DSQL.add_text('OE_ORDER_LINES_ALL OEL, ');

1489:
1490: --BEGIN FROM CLAUSE
1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');
1492: FND_DSQL.add_text('OE_ORDER_HEADERS_ALL OEH, ');
1493: FND_DSQL.add_text('OE_ORDER_LINES_ALL OEL, ');
1494: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');
1496:
1497: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');

Line 1494: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');

1490: --BEGIN FROM CLAUSE
1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');
1492: FND_DSQL.add_text('OE_ORDER_HEADERS_ALL OEH, ');
1493: FND_DSQL.add_text('OE_ORDER_LINES_ALL OEL, ');
1494: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');
1496:
1497: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');
1498: FND_DSQL.add_text('HZ_CUST_ACCT_SITES_ALL HZCAS, ');

Line 1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');

1491: FND_DSQL.add_text('FROM OZF_FUNDS_UTILIZED_ALL_B FU, ');
1492: FND_DSQL.add_text('OE_ORDER_HEADERS_ALL OEH, ');
1493: FND_DSQL.add_text('OE_ORDER_LINES_ALL OEL, ');
1494: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');
1496:
1497: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');
1498: FND_DSQL.add_text('HZ_CUST_ACCT_SITES_ALL HZCAS, ');
1499: FND_DSQL.add_text('HZ_CUST_ACCOUNTS HZCA, ');

Line 1497: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');

1493: FND_DSQL.add_text('OE_ORDER_LINES_ALL OEL, ');
1494: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');
1496:
1497: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');
1498: FND_DSQL.add_text('HZ_CUST_ACCT_SITES_ALL HZCAS, ');
1499: FND_DSQL.add_text('HZ_CUST_ACCOUNTS HZCA, ');
1500: FND_DSQL.add_text('OZF_OFFERS OFRS ');
1501:

Line 1498: FND_DSQL.add_text('HZ_CUST_ACCT_SITES_ALL HZCAS, ');

1494: FND_DSQL.add_text('OZF_SD_REQUEST_HEADERS_ALL_B RH, ');
1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');
1496:
1497: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');
1498: FND_DSQL.add_text('HZ_CUST_ACCT_SITES_ALL HZCAS, ');
1499: FND_DSQL.add_text('HZ_CUST_ACCOUNTS HZCA, ');
1500: FND_DSQL.add_text('OZF_OFFERS OFRS ');
1501:
1502: --BEGIN WHERE CLAUSE

Line 1499: FND_DSQL.add_text('HZ_CUST_ACCOUNTS HZCA, ');

1495: FND_DSQL.add_text('OZF_SD_REQUEST_LINES_ALL RL , ');
1496:
1497: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');
1498: FND_DSQL.add_text('HZ_CUST_ACCT_SITES_ALL HZCAS, ');
1499: FND_DSQL.add_text('HZ_CUST_ACCOUNTS HZCA, ');
1500: FND_DSQL.add_text('OZF_OFFERS OFRS ');
1501:
1502: --BEGIN WHERE CLAUSE
1503:

Line 1500: FND_DSQL.add_text('OZF_OFFERS OFRS ');

1496:
1497: FND_DSQL.add_text('HZ_CUST_SITE_USES_ALL HZCSU, ');
1498: FND_DSQL.add_text('HZ_CUST_ACCT_SITES_ALL HZCAS, ');
1499: FND_DSQL.add_text('HZ_CUST_ACCOUNTS HZCA, ');
1500: FND_DSQL.add_text('OZF_OFFERS OFRS ');
1501:
1502: --BEGIN WHERE CLAUSE
1503:
1504: FND_DSQL.add_text('WHERE RH.OFFER_ID = FU.PLAN_ID AND ');

Line 1504: FND_DSQL.add_text('WHERE RH.OFFER_ID = FU.PLAN_ID AND ');

1500: FND_DSQL.add_text('OZF_OFFERS OFRS ');
1501:
1502: --BEGIN WHERE CLAUSE
1503:
1504: FND_DSQL.add_text('WHERE RH.OFFER_ID = FU.PLAN_ID AND ');
1505: FND_DSQL.add_text('OFRS.QP_LIST_HEADER_ID = RH.OFFER_ID AND ');
1506: FND_DSQL.add_text('FU.OBJECT_ID = OEH.HEADER_ID AND ');
1507: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');
1508: FND_DSQL.add_text('FU.OBJECT_TYPE = ''ORDER'' AND ');

Line 1505: FND_DSQL.add_text('OFRS.QP_LIST_HEADER_ID = RH.OFFER_ID AND ');

1501:
1502: --BEGIN WHERE CLAUSE
1503:
1504: FND_DSQL.add_text('WHERE RH.OFFER_ID = FU.PLAN_ID AND ');
1505: FND_DSQL.add_text('OFRS.QP_LIST_HEADER_ID = RH.OFFER_ID AND ');
1506: FND_DSQL.add_text('FU.OBJECT_ID = OEH.HEADER_ID AND ');
1507: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');
1508: FND_DSQL.add_text('FU.OBJECT_TYPE = ''ORDER'' AND ');
1509: FND_DSQL.add_text('OEL.HEADER_ID = OEH.HEADER_ID AND ');

Line 1506: FND_DSQL.add_text('FU.OBJECT_ID = OEH.HEADER_ID AND ');

1502: --BEGIN WHERE CLAUSE
1503:
1504: FND_DSQL.add_text('WHERE RH.OFFER_ID = FU.PLAN_ID AND ');
1505: FND_DSQL.add_text('OFRS.QP_LIST_HEADER_ID = RH.OFFER_ID AND ');
1506: FND_DSQL.add_text('FU.OBJECT_ID = OEH.HEADER_ID AND ');
1507: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');
1508: FND_DSQL.add_text('FU.OBJECT_TYPE = ''ORDER'' AND ');
1509: FND_DSQL.add_text('OEL.HEADER_ID = OEH.HEADER_ID AND ');
1510: FND_DSQL.add_text('RH.REQUEST_HEADER_ID = RL.REQUEST_HEADER_ID AND ');

Line 1507: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');

1503:
1504: FND_DSQL.add_text('WHERE RH.OFFER_ID = FU.PLAN_ID AND ');
1505: FND_DSQL.add_text('OFRS.QP_LIST_HEADER_ID = RH.OFFER_ID AND ');
1506: FND_DSQL.add_text('FU.OBJECT_ID = OEH.HEADER_ID AND ');
1507: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');
1508: FND_DSQL.add_text('FU.OBJECT_TYPE = ''ORDER'' AND ');
1509: FND_DSQL.add_text('OEL.HEADER_ID = OEH.HEADER_ID AND ');
1510: FND_DSQL.add_text('RH.REQUEST_HEADER_ID = RL.REQUEST_HEADER_ID AND ');
1511:

Line 1508: FND_DSQL.add_text('FU.OBJECT_TYPE = ''ORDER'' AND ');

1504: FND_DSQL.add_text('WHERE RH.OFFER_ID = FU.PLAN_ID AND ');
1505: FND_DSQL.add_text('OFRS.QP_LIST_HEADER_ID = RH.OFFER_ID AND ');
1506: FND_DSQL.add_text('FU.OBJECT_ID = OEH.HEADER_ID AND ');
1507: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');
1508: FND_DSQL.add_text('FU.OBJECT_TYPE = ''ORDER'' AND ');
1509: FND_DSQL.add_text('OEL.HEADER_ID = OEH.HEADER_ID AND ');
1510: FND_DSQL.add_text('RH.REQUEST_HEADER_ID = RL.REQUEST_HEADER_ID AND ');
1511:
1512: FND_DSQL.add_text('RH.SUPPLIER_SITE_ID = ' );

Line 1509: FND_DSQL.add_text('OEL.HEADER_ID = OEH.HEADER_ID AND ');

1505: FND_DSQL.add_text('OFRS.QP_LIST_HEADER_ID = RH.OFFER_ID AND ');
1506: FND_DSQL.add_text('FU.OBJECT_ID = OEH.HEADER_ID AND ');
1507: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');
1508: FND_DSQL.add_text('FU.OBJECT_TYPE = ''ORDER'' AND ');
1509: FND_DSQL.add_text('OEL.HEADER_ID = OEH.HEADER_ID AND ');
1510: FND_DSQL.add_text('RH.REQUEST_HEADER_ID = RL.REQUEST_HEADER_ID AND ');
1511:
1512: FND_DSQL.add_text('RH.SUPPLIER_SITE_ID = ' );
1513: FND_DSQL.add_bind(p_supplier_site_id);

Line 1510: FND_DSQL.add_text('RH.REQUEST_HEADER_ID = RL.REQUEST_HEADER_ID AND ');

1506: FND_DSQL.add_text('FU.OBJECT_ID = OEH.HEADER_ID AND ');
1507: FND_DSQL.add_text('FU.AMOUNT_REMAINING <> 0 AND ');
1508: FND_DSQL.add_text('FU.OBJECT_TYPE = ''ORDER'' AND ');
1509: FND_DSQL.add_text('OEL.HEADER_ID = OEH.HEADER_ID AND ');
1510: FND_DSQL.add_text('RH.REQUEST_HEADER_ID = RL.REQUEST_HEADER_ID AND ');
1511:
1512: FND_DSQL.add_text('RH.SUPPLIER_SITE_ID = ' );
1513: FND_DSQL.add_bind(p_supplier_site_id);
1514: FND_DSQL.add_text(' AND RH.ORG_ID = ' );

Line 1512: FND_DSQL.add_text('RH.SUPPLIER_SITE_ID = ' );

1508: FND_DSQL.add_text('FU.OBJECT_TYPE = ''ORDER'' AND ');
1509: FND_DSQL.add_text('OEL.HEADER_ID = OEH.HEADER_ID AND ');
1510: FND_DSQL.add_text('RH.REQUEST_HEADER_ID = RL.REQUEST_HEADER_ID AND ');
1511:
1512: FND_DSQL.add_text('RH.SUPPLIER_SITE_ID = ' );
1513: FND_DSQL.add_bind(p_supplier_site_id);
1514: FND_DSQL.add_text(' AND RH.ORG_ID = ' );
1515: FND_DSQL.add_bind(l_org_id);
1516:

Line 1513: FND_DSQL.add_bind(p_supplier_site_id);

1509: FND_DSQL.add_text('OEL.HEADER_ID = OEH.HEADER_ID AND ');
1510: FND_DSQL.add_text('RH.REQUEST_HEADER_ID = RL.REQUEST_HEADER_ID AND ');
1511:
1512: FND_DSQL.add_text('RH.SUPPLIER_SITE_ID = ' );
1513: FND_DSQL.add_bind(p_supplier_site_id);
1514: FND_DSQL.add_text(' AND RH.ORG_ID = ' );
1515: FND_DSQL.add_bind(l_org_id);
1516:
1517: FND_DSQL.add_text(' AND OEH.invoice_to_org_id = HZCSU.SITE_USE_ID AND ');

Line 1514: FND_DSQL.add_text(' AND RH.ORG_ID = ' );

1510: FND_DSQL.add_text('RH.REQUEST_HEADER_ID = RL.REQUEST_HEADER_ID AND ');
1511:
1512: FND_DSQL.add_text('RH.SUPPLIER_SITE_ID = ' );
1513: FND_DSQL.add_bind(p_supplier_site_id);
1514: FND_DSQL.add_text(' AND RH.ORG_ID = ' );
1515: FND_DSQL.add_bind(l_org_id);
1516:
1517: FND_DSQL.add_text(' AND OEH.invoice_to_org_id = HZCSU.SITE_USE_ID AND ');
1518: FND_DSQL.add_text('HZCSU.CUST_ACCT_SITE_ID = HZCAS.CUST_ACCT_SITE_ID AND ');

Line 1515: FND_DSQL.add_bind(l_org_id);

1511:
1512: FND_DSQL.add_text('RH.SUPPLIER_SITE_ID = ' );
1513: FND_DSQL.add_bind(p_supplier_site_id);
1514: FND_DSQL.add_text(' AND RH.ORG_ID = ' );
1515: FND_DSQL.add_bind(l_org_id);
1516:
1517: FND_DSQL.add_text(' AND OEH.invoice_to_org_id = HZCSU.SITE_USE_ID AND ');
1518: FND_DSQL.add_text('HZCSU.CUST_ACCT_SITE_ID = HZCAS.CUST_ACCT_SITE_ID AND ');
1519: FND_DSQL.add_text('HZCAS.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID AND ');

Line 1517: FND_DSQL.add_text(' AND OEH.invoice_to_org_id = HZCSU.SITE_USE_ID AND ');

1513: FND_DSQL.add_bind(p_supplier_site_id);
1514: FND_DSQL.add_text(' AND RH.ORG_ID = ' );
1515: FND_DSQL.add_bind(l_org_id);
1516:
1517: FND_DSQL.add_text(' AND OEH.invoice_to_org_id = HZCSU.SITE_USE_ID AND ');
1518: FND_DSQL.add_text('HZCSU.CUST_ACCT_SITE_ID = HZCAS.CUST_ACCT_SITE_ID AND ');
1519: FND_DSQL.add_text('HZCAS.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID AND ');
1520:
1521: FND_DSQL.add_text('((FU.PRODUCT_ID = RL.INVENTORY_ITEM_ID ) OR ');

Line 1518: FND_DSQL.add_text('HZCSU.CUST_ACCT_SITE_ID = HZCAS.CUST_ACCT_SITE_ID AND ');

1514: FND_DSQL.add_text(' AND RH.ORG_ID = ' );
1515: FND_DSQL.add_bind(l_org_id);
1516:
1517: FND_DSQL.add_text(' AND OEH.invoice_to_org_id = HZCSU.SITE_USE_ID AND ');
1518: FND_DSQL.add_text('HZCSU.CUST_ACCT_SITE_ID = HZCAS.CUST_ACCT_SITE_ID AND ');
1519: FND_DSQL.add_text('HZCAS.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID AND ');
1520:
1521: FND_DSQL.add_text('((FU.PRODUCT_ID = RL.INVENTORY_ITEM_ID ) OR ');
1522: FND_DSQL.add_text('FU.PRODUCT_ID IN

Line 1519: FND_DSQL.add_text('HZCAS.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID AND ');

1515: FND_DSQL.add_bind(l_org_id);
1516:
1517: FND_DSQL.add_text(' AND OEH.invoice_to_org_id = HZCSU.SITE_USE_ID AND ');
1518: FND_DSQL.add_text('HZCSU.CUST_ACCT_SITE_ID = HZCAS.CUST_ACCT_SITE_ID AND ');
1519: FND_DSQL.add_text('HZCAS.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID AND ');
1520:
1521: FND_DSQL.add_text('((FU.PRODUCT_ID = RL.INVENTORY_ITEM_ID ) OR ');
1522: FND_DSQL.add_text('FU.PRODUCT_ID IN
1523: (SELECT MIC.INVENTORY_ITEM_ID

Line 1521: FND_DSQL.add_text('((FU.PRODUCT_ID = RL.INVENTORY_ITEM_ID ) OR ');

1517: FND_DSQL.add_text(' AND OEH.invoice_to_org_id = HZCSU.SITE_USE_ID AND ');
1518: FND_DSQL.add_text('HZCSU.CUST_ACCT_SITE_ID = HZCAS.CUST_ACCT_SITE_ID AND ');
1519: FND_DSQL.add_text('HZCAS.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID AND ');
1520:
1521: FND_DSQL.add_text('((FU.PRODUCT_ID = RL.INVENTORY_ITEM_ID ) OR ');
1522: FND_DSQL.add_text('FU.PRODUCT_ID IN
1523: (SELECT MIC.INVENTORY_ITEM_ID
1524: FROM MTL_ITEM_CATEGORIES MIC,
1525: ENI_PROD_DEN_HRCHY_PARENTS_V P,

Line 1522: FND_DSQL.add_text('FU.PRODUCT_ID IN

1518: FND_DSQL.add_text('HZCSU.CUST_ACCT_SITE_ID = HZCAS.CUST_ACCT_SITE_ID AND ');
1519: FND_DSQL.add_text('HZCAS.CUST_ACCOUNT_ID = HZCA.CUST_ACCOUNT_ID AND ');
1520:
1521: FND_DSQL.add_text('((FU.PRODUCT_ID = RL.INVENTORY_ITEM_ID ) OR ');
1522: FND_DSQL.add_text('FU.PRODUCT_ID IN
1523: (SELECT MIC.INVENTORY_ITEM_ID
1524: FROM MTL_ITEM_CATEGORIES MIC,
1525: ENI_PROD_DEN_HRCHY_PARENTS_V P,
1526: ENI_PROD_DENORM_HRCHY_V H,

Line 1537: FND_DSQL.add_text('FU.ORDER_LINE_ID = OEL.LINE_ID AND ');

1533: (P.DISABLE_DATE is null OR P.DISABLE_DATE > SYSDATE)
1534: AND
1535: H.PARENT_ID = RL.prod_catg_id )) AND ');
1536:
1537: FND_DSQL.add_text('FU.ORDER_LINE_ID = OEL.LINE_ID AND ');
1538: FND_DSQL.add_text('FU.GL_POSTED_FLAG = ''Y'' AND ');
1539:
1540:
1541: IF l_ozf_gl_entries = 'SHIPPED' THEN

Line 1538: FND_DSQL.add_text('FU.GL_POSTED_FLAG = ''Y'' AND ');

1534: AND
1535: H.PARENT_ID = RL.prod_catg_id )) AND ');
1536:
1537: FND_DSQL.add_text('FU.ORDER_LINE_ID = OEL.LINE_ID AND ');
1538: FND_DSQL.add_text('FU.GL_POSTED_FLAG = ''Y'' AND ');
1539:
1540:
1541: IF l_ozf_gl_entries = 'SHIPPED' THEN
1542: FND_DSQL.add_text('oel.cancelled_flag = ''N'' AND oel.booked_flag = ''Y'' AND ');

Line 1542: FND_DSQL.add_text('oel.cancelled_flag = ''N'' AND oel.booked_flag = ''Y'' AND ');

1538: FND_DSQL.add_text('FU.GL_POSTED_FLAG = ''Y'' AND ');
1539:
1540:
1541: IF l_ozf_gl_entries = 'SHIPPED' THEN
1542: FND_DSQL.add_text('oel.cancelled_flag = ''N'' AND oel.booked_flag = ''Y'' AND ');
1543: END IF;
1544: IF l_ozf_gl_entries = 'INVOICED' THEN
1545: FND_DSQL.add_text('oel.cancelled_flag = ''N'' AND oel.booked_flag = ''Y'' AND oel.flow_status_code in (''CLOSED'',''INVOICED'') AND ');
1546: END IF;

Line 1545: FND_DSQL.add_text('oel.cancelled_flag = ''N'' AND oel.booked_flag = ''Y'' AND oel.flow_status_code in (''CLOSED'',''INVOICED'') AND ');

1541: IF l_ozf_gl_entries = 'SHIPPED' THEN
1542: FND_DSQL.add_text('oel.cancelled_flag = ''N'' AND oel.booked_flag = ''Y'' AND ');
1543: END IF;
1544: IF l_ozf_gl_entries = 'INVOICED' THEN
1545: FND_DSQL.add_text('oel.cancelled_flag = ''N'' AND oel.booked_flag = ''Y'' AND oel.flow_status_code in (''CLOSED'',''INVOICED'') AND ');
1546: END IF;
1547:
1548: FND_DSQL.add_text(' RH.OFFER_TYPE= ''ACCRUAL'' ');
1549: -- FND_DSQL.add_text(' RL.ORG_ID =' || l_org_id); -- AND '); --this was commented already

Line 1548: FND_DSQL.add_text(' RH.OFFER_TYPE= ''ACCRUAL'' ');

1544: IF l_ozf_gl_entries = 'INVOICED' THEN
1545: FND_DSQL.add_text('oel.cancelled_flag = ''N'' AND oel.booked_flag = ''Y'' AND oel.flow_status_code in (''CLOSED'',''INVOICED'') AND ');
1546: END IF;
1547:
1548: FND_DSQL.add_text(' RH.OFFER_TYPE= ''ACCRUAL'' ');
1549: -- FND_DSQL.add_text(' RL.ORG_ID =' || l_org_id); -- AND '); --this was commented already
1550:
1551: IF g_currency IS NULL THEN
1552: -- currency not set on trade profile

Line 1549: -- FND_DSQL.add_text(' RL.ORG_ID =' || l_org_id); -- AND '); --this was commented already

1545: FND_DSQL.add_text('oel.cancelled_flag = ''N'' AND oel.booked_flag = ''Y'' AND oel.flow_status_code in (''CLOSED'',''INVOICED'') AND ');
1546: END IF;
1547:
1548: FND_DSQL.add_text(' RH.OFFER_TYPE= ''ACCRUAL'' ');
1549: -- FND_DSQL.add_text(' RL.ORG_ID =' || l_org_id); -- AND '); --this was commented already
1550:
1551: IF g_currency IS NULL THEN
1552: -- currency not set on trade profile
1553: FND_DSQL.add_text(' AND RH.REQUEST_CURRENCY_CODE = ' );

Line 1553: FND_DSQL.add_text(' AND RH.REQUEST_CURRENCY_CODE = ' );

1549: -- FND_DSQL.add_text(' RL.ORG_ID =' || l_org_id); -- AND '); --this was commented already
1550:
1551: IF g_currency IS NULL THEN
1552: -- currency not set on trade profile
1553: FND_DSQL.add_text(' AND RH.REQUEST_CURRENCY_CODE = ' );
1554: FND_DSQL.add_bind('' || l_batch_currency || '');
1555: END IF;
1556:
1557: --request ID filter

Line 1554: FND_DSQL.add_bind('' || l_batch_currency || '');

1550:
1551: IF g_currency IS NULL THEN
1552: -- currency not set on trade profile
1553: FND_DSQL.add_text(' AND RH.REQUEST_CURRENCY_CODE = ' );
1554: FND_DSQL.add_bind('' || l_batch_currency || '');
1555: END IF;
1556:
1557: --request ID filter
1558: IF p_request_id is not null then

Line 1559: FND_DSQL.add_text(' AND RH.REQUEST_HEADER_ID = ' );

1555: END IF;
1556:
1557: --request ID filter
1558: IF p_request_id is not null then
1559: FND_DSQL.add_text(' AND RH.REQUEST_HEADER_ID = ' );
1560: FND_DSQL.add_bind(p_request_id);
1561: END IF;
1562:
1563: --product filter

Line 1560: FND_DSQL.add_bind(p_request_id);

1556:
1557: --request ID filter
1558: IF p_request_id is not null then
1559: FND_DSQL.add_text(' AND RH.REQUEST_HEADER_ID = ' );
1560: FND_DSQL.add_bind(p_request_id);
1561: END IF;
1562:
1563: --product filter
1564: IF p_product_id is not null then

Line 1565: FND_DSQL.add_text(' AND FU.PRODUCT_ID = ' );

1561: END IF;
1562:
1563: --product filter
1564: IF p_product_id is not null then
1565: FND_DSQL.add_text(' AND FU.PRODUCT_ID = ' );
1566: FND_DSQL.add_bind(p_product_id);
1567: END IF;
1568:
1569: -- offer filter

Line 1566: FND_DSQL.add_bind(p_product_id);

1562:
1563: --product filter
1564: IF p_product_id is not null then
1565: FND_DSQL.add_text(' AND FU.PRODUCT_ID = ' );
1566: FND_DSQL.add_bind(p_product_id);
1567: END IF;
1568:
1569: -- offer filter
1570: IF p_fund_id is not null then

Line 1571: FND_DSQL.add_text(' AND FU.fund_id = ' );

1567: END IF;
1568:
1569: -- offer filter
1570: IF p_fund_id is not null then
1571: FND_DSQL.add_text(' AND FU.fund_id = ' );
1572: FND_DSQL.add_bind(p_fund_id);
1573: END IF;
1574:
1575: --start date filter

Line 1572: FND_DSQL.add_bind(p_fund_id);

1568:
1569: -- offer filter
1570: IF p_fund_id is not null then
1571: FND_DSQL.add_text(' AND FU.fund_id = ' );
1572: FND_DSQL.add_bind(p_fund_id);
1573: END IF;
1574:
1575: --start date filter
1576: IF p_start_date is not null then

Line 1577: FND_DSQL.add_text(' AND FU.creation_date >=' );

1573: END IF;
1574:
1575: --start date filter
1576: IF p_start_date is not null then
1577: FND_DSQL.add_text(' AND FU.creation_date >=' );
1578: FND_DSQL.add_bind('' || p_start_date || '');
1579: END IF;
1580:
1581: --end date filter

Line 1578: FND_DSQL.add_bind('' || p_start_date || '');

1574:
1575: --start date filter
1576: IF p_start_date is not null then
1577: FND_DSQL.add_text(' AND FU.creation_date >=' );
1578: FND_DSQL.add_bind('' || p_start_date || '');
1579: END IF;
1580:
1581: --end date filter
1582: IF p_end_date is not null then

Line 1583: FND_DSQL.add_text(' AND FU.creation_date <=' );

1579: END IF;
1580:
1581: --end date filter
1582: IF p_end_date is not null then
1583: FND_DSQL.add_text(' AND FU.creation_date <=' );
1584: FND_DSQL.add_bind('' || p_end_date || '');
1585: END IF;
1586:
1587: --period filter

Line 1584: FND_DSQL.add_bind('' || p_end_date || '');

1580:
1581: --end date filter
1582: IF p_end_date is not null then
1583: FND_DSQL.add_text(' AND FU.creation_date <=' );
1584: FND_DSQL.add_bind('' || p_end_date || '');
1585: END IF;
1586:
1587: --period filter
1588: IF p_period is not null then

Line 1595: FND_DSQL.add_text(' AND FU.creation_date >= ');

1591: INTO l_period_start, l_period_end;
1592: CLOSE get_period_limits;
1593:
1594: IF l_period_start is not null then
1595: FND_DSQL.add_text(' AND FU.creation_date >= ');
1596: FND_DSQL.add_bind(''||to_date(to_char(l_period_start,'DD-MM-YYYY'),'DD-MM-YYYY')||'');
1597: END IF;
1598:
1599: IF l_period_end is not null then

Line 1596: FND_DSQL.add_bind(''||to_date(to_char(l_period_start,'DD-MM-YYYY'),'DD-MM-YYYY')||'');

1592: CLOSE get_period_limits;
1593:
1594: IF l_period_start is not null then
1595: FND_DSQL.add_text(' AND FU.creation_date >= ');
1596: FND_DSQL.add_bind(''||to_date(to_char(l_period_start,'DD-MM-YYYY'),'DD-MM-YYYY')||'');
1597: END IF;
1598:
1599: IF l_period_end is not null then
1600: FND_DSQL.add_text(' AND FU.creation_date <= ');

Line 1600: FND_DSQL.add_text(' AND FU.creation_date <= ');

1596: FND_DSQL.add_bind(''||to_date(to_char(l_period_start,'DD-MM-YYYY'),'DD-MM-YYYY')||'');
1597: END IF;
1598:
1599: IF l_period_end is not null then
1600: FND_DSQL.add_text(' AND FU.creation_date <= ');
1601: FND_DSQL.add_bind(''||to_date(to_char(l_period_end,'DD-MM-YYYY'),'DD-MM-YYYY')||'');
1602: END IF;
1603:
1604: END IF;

Line 1601: FND_DSQL.add_bind(''||to_date(to_char(l_period_end,'DD-MM-YYYY'),'DD-MM-YYYY')||'');

1597: END IF;
1598:
1599: IF l_period_end is not null then
1600: FND_DSQL.add_text(' AND FU.creation_date <= ');
1601: FND_DSQL.add_bind(''||to_date(to_char(l_period_end,'DD-MM-YYYY'),'DD-MM-YYYY')||'');
1602: END IF;
1603:
1604: END IF;
1605:

Line 1608: FND_DSQL.add_text(' AND FU.ATTRIBUTE1 =' );

1604: END IF;
1605:
1606: -- attribute1 filter
1607: IF p_attribute1 is not null then
1608: FND_DSQL.add_text(' AND FU.ATTRIBUTE1 =' );
1609: FND_DSQL.add_bind('' || p_attribute1 || '');
1610: END IF;
1611:
1612: -- attribute2 filter

Line 1609: FND_DSQL.add_bind('' || p_attribute1 || '');

1605:
1606: -- attribute1 filter
1607: IF p_attribute1 is not null then
1608: FND_DSQL.add_text(' AND FU.ATTRIBUTE1 =' );
1609: FND_DSQL.add_bind('' || p_attribute1 || '');
1610: END IF;
1611:
1612: -- attribute2 filter
1613: IF p_attribute2 is not null then

Line 1614: FND_DSQL.add_text(' AND FU.ATTRIBUTE2 =' );

1610: END IF;
1611:
1612: -- attribute2 filter
1613: IF p_attribute2 is not null then
1614: FND_DSQL.add_text(' AND FU.ATTRIBUTE2 =' );
1615: FND_DSQL.add_bind('' || p_attribute2 || '');
1616: END IF;
1617:
1618: -- attribute3 filter

Line 1615: FND_DSQL.add_bind('' || p_attribute2 || '');

1611:
1612: -- attribute2 filter
1613: IF p_attribute2 is not null then
1614: FND_DSQL.add_text(' AND FU.ATTRIBUTE2 =' );
1615: FND_DSQL.add_bind('' || p_attribute2 || '');
1616: END IF;
1617:
1618: -- attribute3 filter
1619: IF p_attribute3 is not null then

Line 1620: FND_DSQL.add_text(' AND FU.ATTRIBUTE3 =' );

1616: END IF;
1617:
1618: -- attribute3 filter
1619: IF p_attribute3 is not null then
1620: FND_DSQL.add_text(' AND FU.ATTRIBUTE3 =' );
1621: FND_DSQL.add_bind('' || p_attribute3 || '');
1622: END IF;
1623:
1624: -- attribute4 filter

Line 1621: FND_DSQL.add_bind('' || p_attribute3 || '');

1617:
1618: -- attribute3 filter
1619: IF p_attribute3 is not null then
1620: FND_DSQL.add_text(' AND FU.ATTRIBUTE3 =' );
1621: FND_DSQL.add_bind('' || p_attribute3 || '');
1622: END IF;
1623:
1624: -- attribute4 filter
1625: IF p_attribute4 is not null then

Line 1626: FND_DSQL.add_text(' AND FU.ATTRIBUTE4 =' );

1622: END IF;
1623:
1624: -- attribute4 filter
1625: IF p_attribute4 is not null then
1626: FND_DSQL.add_text(' AND FU.ATTRIBUTE4 =' );
1627: FND_DSQL.add_bind('' || p_attribute4 || '');
1628: END IF;
1629:
1630: -- attribute5 filter

Line 1627: FND_DSQL.add_bind('' || p_attribute4 || '');

1623:
1624: -- attribute4 filter
1625: IF p_attribute4 is not null then
1626: FND_DSQL.add_text(' AND FU.ATTRIBUTE4 =' );
1627: FND_DSQL.add_bind('' || p_attribute4 || '');
1628: END IF;
1629:
1630: -- attribute5 filter
1631: IF p_attribute5 is not null then

Line 1632: FND_DSQL.add_text(' AND FU.ATTRIBUTE5 =' );

1628: END IF;
1629:
1630: -- attribute5 filter
1631: IF p_attribute5 is not null then
1632: FND_DSQL.add_text(' AND FU.ATTRIBUTE5 =' );
1633: FND_DSQL.add_bind('' || p_attribute5 || '');
1634: END IF;
1635:
1636: -- attribute6 filter

Line 1633: FND_DSQL.add_bind('' || p_attribute5 || '');

1629:
1630: -- attribute5 filter
1631: IF p_attribute5 is not null then
1632: FND_DSQL.add_text(' AND FU.ATTRIBUTE5 =' );
1633: FND_DSQL.add_bind('' || p_attribute5 || '');
1634: END IF;
1635:
1636: -- attribute6 filter
1637: IF p_attribute6 is not null then

Line 1638: FND_DSQL.add_text(' AND FU.ATTRIBUTE6 =' );

1634: END IF;
1635:
1636: -- attribute6 filter
1637: IF p_attribute6 is not null then
1638: FND_DSQL.add_text(' AND FU.ATTRIBUTE6 =' );
1639: FND_DSQL.add_bind('' || p_attribute6 || '');
1640: END IF;
1641:
1642: -- attribute7 filter

Line 1639: FND_DSQL.add_bind('' || p_attribute6 || '');

1635:
1636: -- attribute6 filter
1637: IF p_attribute6 is not null then
1638: FND_DSQL.add_text(' AND FU.ATTRIBUTE6 =' );
1639: FND_DSQL.add_bind('' || p_attribute6 || '');
1640: END IF;
1641:
1642: -- attribute7 filter
1643: IF p_attribute7 is not null then

Line 1644: FND_DSQL.add_text(' AND FU.ATTRIBUTE7 =' );

1640: END IF;
1641:
1642: -- attribute7 filter
1643: IF p_attribute7 is not null then
1644: FND_DSQL.add_text(' AND FU.ATTRIBUTE7 =' );
1645: FND_DSQL.add_bind('' || p_attribute7 || '');
1646: END IF;
1647:
1648: -- attribute8 filter

Line 1645: FND_DSQL.add_bind('' || p_attribute7 || '');

1641:
1642: -- attribute7 filter
1643: IF p_attribute7 is not null then
1644: FND_DSQL.add_text(' AND FU.ATTRIBUTE7 =' );
1645: FND_DSQL.add_bind('' || p_attribute7 || '');
1646: END IF;
1647:
1648: -- attribute8 filter
1649: IF p_attribute8 is not null then

Line 1650: FND_DSQL.add_text(' AND FU.ATTRIBUTE8 =' );

1646: END IF;
1647:
1648: -- attribute8 filter
1649: IF p_attribute8 is not null then
1650: FND_DSQL.add_text(' AND FU.ATTRIBUTE8 =' );
1651: FND_DSQL.add_bind('' || p_attribute8 || '');
1652: END IF;
1653:
1654: -- attribute9 filter

Line 1651: FND_DSQL.add_bind('' || p_attribute8 || '');

1647:
1648: -- attribute8 filter
1649: IF p_attribute8 is not null then
1650: FND_DSQL.add_text(' AND FU.ATTRIBUTE8 =' );
1651: FND_DSQL.add_bind('' || p_attribute8 || '');
1652: END IF;
1653:
1654: -- attribute9 filter
1655: IF p_attribute9 is not null then

Line 1656: FND_DSQL.add_text(' AND FU.ATTRIBUTE9 =' );

1652: END IF;
1653:
1654: -- attribute9 filter
1655: IF p_attribute9 is not null then
1656: FND_DSQL.add_text(' AND FU.ATTRIBUTE9 =' );
1657: FND_DSQL.add_bind('' || p_attribute9 || '');
1658: END IF;
1659:
1660: -- attribute10 filter

Line 1657: FND_DSQL.add_bind('' || p_attribute9 || '');

1653:
1654: -- attribute9 filter
1655: IF p_attribute9 is not null then
1656: FND_DSQL.add_text(' AND FU.ATTRIBUTE9 =' );
1657: FND_DSQL.add_bind('' || p_attribute9 || '');
1658: END IF;
1659:
1660: -- attribute10 filter
1661: IF p_attribute10 is not null then

Line 1662: FND_DSQL.add_text(' AND FU.ATTRIBute10 =' );

1658: END IF;
1659:
1660: -- attribute10 filter
1661: IF p_attribute10 is not null then
1662: FND_DSQL.add_text(' AND FU.ATTRIBute10 =' );
1663: FND_DSQL.add_bind('' || p_attribute10 || '');
1664: END IF;
1665:
1666: -- attribute11 filter

Line 1663: FND_DSQL.add_bind('' || p_attribute10 || '');

1659:
1660: -- attribute10 filter
1661: IF p_attribute10 is not null then
1662: FND_DSQL.add_text(' AND FU.ATTRIBute10 =' );
1663: FND_DSQL.add_bind('' || p_attribute10 || '');
1664: END IF;
1665:
1666: -- attribute11 filter
1667: IF p_attribute11 is not null then

Line 1668: FND_DSQL.add_text(' AND FU.ATTRIBute11 =' );

1664: END IF;
1665:
1666: -- attribute11 filter
1667: IF p_attribute11 is not null then
1668: FND_DSQL.add_text(' AND FU.ATTRIBute11 =' );
1669: FND_DSQL.add_bind('' || p_attribute11 || '');
1670: END IF;
1671:
1672: -- attribute12 filter

Line 1669: FND_DSQL.add_bind('' || p_attribute11 || '');

1665:
1666: -- attribute11 filter
1667: IF p_attribute11 is not null then
1668: FND_DSQL.add_text(' AND FU.ATTRIBute11 =' );
1669: FND_DSQL.add_bind('' || p_attribute11 || '');
1670: END IF;
1671:
1672: -- attribute12 filter
1673: IF p_attribute12 is not null then

Line 1674: FND_DSQL.add_text(' AND FU.ATTRIBute12 =' );

1670: END IF;
1671:
1672: -- attribute12 filter
1673: IF p_attribute12 is not null then
1674: FND_DSQL.add_text(' AND FU.ATTRIBute12 =' );
1675: FND_DSQL.add_bind('' || p_attribute12 || '');
1676: END IF;
1677:
1678: -- attribute13 filter

Line 1675: FND_DSQL.add_bind('' || p_attribute12 || '');

1671:
1672: -- attribute12 filter
1673: IF p_attribute12 is not null then
1674: FND_DSQL.add_text(' AND FU.ATTRIBute12 =' );
1675: FND_DSQL.add_bind('' || p_attribute12 || '');
1676: END IF;
1677:
1678: -- attribute13 filter
1679: IF p_attribute13 is not null then

Line 1680: FND_DSQL.add_text(' AND FU.ATTRIBute13 =' );

1676: END IF;
1677:
1678: -- attribute13 filter
1679: IF p_attribute13 is not null then
1680: FND_DSQL.add_text(' AND FU.ATTRIBute13 =' );
1681: FND_DSQL.add_bind('' || p_attribute13 || '');
1682: END IF;
1683:
1684: -- attribute14 filter

Line 1681: FND_DSQL.add_bind('' || p_attribute13 || '');

1677:
1678: -- attribute13 filter
1679: IF p_attribute13 is not null then
1680: FND_DSQL.add_text(' AND FU.ATTRIBute13 =' );
1681: FND_DSQL.add_bind('' || p_attribute13 || '');
1682: END IF;
1683:
1684: -- attribute14 filter
1685: IF p_attribute14 is not null then

Line 1686: FND_DSQL.add_text(' AND FU.ATTRIBute14 =' );

1682: END IF;
1683:
1684: -- attribute14 filter
1685: IF p_attribute14 is not null then
1686: FND_DSQL.add_text(' AND FU.ATTRIBute14 =' );
1687: FND_DSQL.add_bind('' || p_attribute14 || '');
1688: END IF;
1689:
1690: -- attribute15 filter

Line 1687: FND_DSQL.add_bind('' || p_attribute14 || '');

1683:
1684: -- attribute14 filter
1685: IF p_attribute14 is not null then
1686: FND_DSQL.add_text(' AND FU.ATTRIBute14 =' );
1687: FND_DSQL.add_bind('' || p_attribute14 || '');
1688: END IF;
1689:
1690: -- attribute15 filter
1691: IF p_attribute15 is not null then

Line 1692: FND_DSQL.add_text(' AND FU.ATTRIBute15 =' );

1688: END IF;
1689:
1690: -- attribute15 filter
1691: IF p_attribute15 is not null then
1692: FND_DSQL.add_text(' AND FU.ATTRIBute15 =' );
1693: FND_DSQL.add_bind('' || p_attribute15 || '');
1694: END IF;
1695:
1696: --creating cursor

Line 1693: FND_DSQL.add_bind('' || p_attribute15 || '');

1689:
1690: -- attribute15 filter
1691: IF p_attribute15 is not null then
1692: FND_DSQL.add_text(' AND FU.ATTRIBute15 =' );
1693: FND_DSQL.add_bind('' || p_attribute15 || '');
1694: END IF;
1695:
1696: --creating cursor
1697: l_lines_csr := DBMS_SQL.open_cursor;

Line 1698: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above

1694: END IF;
1695:
1696: --creating cursor
1697: l_lines_csr := DBMS_SQL.open_cursor;
1698: l_lines_sql := FND_DSQL.get_text(FALSE); -- Get SQL query built above
1699:
1700: IF OZF_DEBUG_LOW_ON THEN
1701: FND_FILE.PUT_LINE(FND_FILE.LOG, '---Start Query Text ---');
1702: FND_FILE.PUT_LINE(FND_FILE.LOG,' l_lines_sql = ' || l_lines_sql);

Line 1722: FND_DSQL.set_cursor(l_lines_csr);

1718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' l_lines_sql = ' || l_lines_sql);
1719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' --End Query Text --');
1720: END IF;
1721:
1722: FND_DSQL.set_cursor(l_lines_csr);
1723: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
1724: FND_DSQL.do_binds;
1725:
1726: --define columns

Line 1724: FND_DSQL.do_binds;

1720: END IF;
1721:
1722: FND_DSQL.set_cursor(l_lines_csr);
1723: DBMS_SQL.parse(l_lines_csr, l_lines_sql, DBMS_SQL.native);
1724: FND_DSQL.do_binds;
1725:
1726: --define columns
1727:
1728: DBMS_SQL.define_column(l_lines_csr, 1, l_batch_line_id);