DBA Data[Home] [Help]

APPS.CST_PENDINGTXNSREPORT_PVT dependencies on MTL_PARAMETERS

Line 519: FROM mtl_parameters

515:
516: l_stmt_num := 10;
517: SELECT ORGANIZATION_CODE
518: INTO l_org_code
519: FROM mtl_parameters
520: WHERE organization_id = i_org_id;
521:
522: l_stmt_num := 20;
523: SELECT PERIOD_NAME

Line 886: mtl_parameters mp

882: FROM mtl_material_transactions mmt,
883: mtl_item_flexfields mif,
884: mtl_transaction_types mtt,
885: mtl_txn_source_types mtst,
886: mtl_parameters mp
887: WHERE mmt.organization_id = :i_org_id
888: AND mmt.transaction_date <= :i_period_end_date
889: AND mmt.costed_flag in (''N'',''E'')
890: AND mmt.inventory_item_id = mif.inventory_item_id (+)

Line 1565: mtl_parameters mp,

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,
1566: mfg_lookups ml1,
1567: mfg_lookups ml2,
1568: mfg_lookups ml3,
1569: mfg_lookups ml4,