DBA Data[Home] [Help]

APPS.CST_PENDINGTXNSREPORT_PVT dependencies on MTL_PARAMETERS

Line 505: FROM mtl_parameters

501:
502: l_stmt_num := 10;
503: SELECT ORGANIZATION_CODE
504: INTO l_org_code
505: FROM mtl_parameters
506: WHERE organization_id = i_org_id;
507:
508: l_stmt_num := 20;
509: SELECT PERIOD_NAME

Line 872: mtl_parameters mp

868: FROM mtl_material_transactions mmt,
869: mtl_item_flexfields mif,
870: mtl_transaction_types mtt,
871: mtl_txn_source_types mtst,
872: mtl_parameters mp
873: WHERE mmt.organization_id = :i_org_id
874: AND mmt.transaction_date <= :i_period_end_date
875: AND mmt.costed_flag in (''N'',''E'')
876: AND mmt.inventory_item_id = mif.inventory_item_id (+)

Line 1551: mtl_parameters mp,

1547: FROM mtl_transactions_interface mti,
1548: mtl_item_flexfields mif,
1549: mtl_serial_numbers_interface msni,
1550: mtl_transaction_lots_interface mtli,
1551: mtl_parameters mp,
1552: mfg_lookups ml1,
1553: mfg_lookups ml2,
1554: mfg_lookups ml3,
1555: mfg_lookups ml4,