APPS.CST_PENDINGTXNSREPORT_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1471: l_min_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;

1467: l_ctx NUMBER;
1468: l_xml_temp CLOB;
1469: l_offset PLS_INTEGER;
1470: l_stmt_num NUMBER;
1471: l_min_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;
1472: l_max_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;
1473: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1474: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.' || l_full_name;
1475:

Line 1472: l_max_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;

1468: l_xml_temp CLOB;
1469: l_offset PLS_INTEGER;
1470: l_stmt_num NUMBER;
1471: l_min_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;
1472: l_max_txn_if_id MTL_TRANSACTIONS_INTERFACE.TRANSACTION_INTERFACE_ID%TYPE;
1473: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
1474: l_module CONSTANT VARCHAR2(70) := 'cst.plsql.' || l_full_name;
1475:
1476: l_uLog CONSTANT BOOLEAN := FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL AND FND_LOG.TEST (FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 1508: FROM mtl_transactions_interface

1504: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1505:
1506: SELECT min (TRANSACTION_INTERFACE_ID)
1507: INTO l_min_txn_if_id
1508: FROM mtl_transactions_interface
1509: WHERE organization_id = i_org_id
1510: AND transaction_date <= i_period_end_date
1511: AND process_flag <> 9;
1512:

Line 1515: FROM mtl_transactions_interface

1511: AND process_flag <> 9;
1512:
1513: SELECT max (TRANSACTION_INTERFACE_ID)
1514: INTO l_max_txn_if_id
1515: FROM mtl_transactions_interface
1516: WHERE organization_id = i_org_id
1517: AND transaction_date <= i_period_end_date
1518: AND process_flag <> 9;
1519:

Line 1561: FROM mtl_transactions_interface mti,

1557: ml1.meaning LOCK_FLAG_DESC,
1558: mti.LOCK_FLAG,
1559: mti.ERROR_CODE,
1560: mti.ERROR_EXPLANATION
1561: FROM mtl_transactions_interface mti,
1562: mtl_item_flexfields mif,
1563: mtl_serial_numbers_interface msni,
1564: mtl_transaction_lots_interface mtli,
1565: mtl_parameters mp,