DBA Data[Home] [Help]

APPS.CSTPMRGL dependencies on MTL_TRANSACTION_ACCOUNTS

Line 1060: mtl_transaction_accounts mta,

1056: mta.reference_account
1057: FROM cst_margin_build cr,
1058: cst_acct_info_v ood,
1059: mtl_material_transactions mmt,
1060: mtl_transaction_accounts mta,
1061: oe_order_lines_all sl_child,
1062: oe_order_lines_all sl_parent,
1063: oe_order_headers_all sh,
1064: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */

Line 1275: (SELECT 1 FROM mtl_transaction_accounts mta

1271: mmt.primary_quantity = 0
1272: OR crcml.unit_cost=0
1273: )
1274: AND NOT EXISTS
1275: (SELECT 1 FROM mtl_transaction_accounts mta
1276: WHERE mta.transaction_id=mmt.transaction_id)
1277: );
1278:
1279: /*- -------------------------------------------------------------+

Line 1479: mtl_transaction_accounts mta,

1475: oe_order_headers_all rma,
1476: oe_order_lines_all rma_line,
1477: mtl_material_transactions mmt,
1478: cst_organization_definitions cod,
1479: mtl_transaction_accounts mta,
1480: mtl_parameters mp /* INVCONV umoogala 17-oct-2004 */
1481: WHERE cr.build_id = l_build_id
1482: AND (mmt.transaction_source_type_id = 12 -- dropship <
1483: OR mmt.transaction_action_id = 14) -- logical I/C sales return