[Home] [Help]
581: oap.acct_period_id,
582: msi.inventory_asset_flag
583: FROM cst_lc_adj_interface li,
584: gl_period_statuses gps,
585: mtl_system_items_b msi,
586: po_headers_all poh,
587: org_acct_periods oap,
588: rcv_transactions rt
589: WHERE li.group_id = p_group_id
1542: FROM cst_lc_adj_acctg_info_gt acc,
1543: cst_lc_rcv_txn_gt rt,
1544: mtl_secondary_inventories mse,
1545: mtl_material_transactions mmt,
1546: mtl_system_items_b msi
1547: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')
1548: or (rt.transaction_type = 'CORRECT'
1549: and rt.parent_transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')))
1550: and rt.lcm_transaction_id = acc.lcm_transaction_id
1701: and mse.organization_id = acc.organization_id
1702: and mmt.rcv_transaction_id = rt.rcv_transaction_id
1703: and mmt.transaction_id = mclacd.transaction_id
1704: AND (acc.inventory_asset_flag = 'Y' AND Nvl(mse.asset_inventory,2) = 1)) txn,
1705: mtl_system_items_b msi
1706: WHERE msi.inventory_item_id = txn.inventory_item_id
1707: AND msi.organization_id= txn.organization_id
1708: GROUP BY txn.lcm_transaction_id, txn.COST_GROUP_ID,
1709: txn.INV_LAYER_ID,
2714: po_distributions_all pod,
2715: gl_period_statuses gps,
2716: cst_acct_info_v cai,
2717: mtl_parameters mp,
2718: mtl_system_items_b msi,
2719: rcv_parameters rp
2720: WHERE oap.organization_id (+) = clai.organization_id
2721: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) >= Trunc(oap.period_start_date)
2722: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_SERVER(clai.transaction_date, cai.legal_entity) <= Trunc(oap.schedule_close_date)