DBA Data[Home] [Help]

APPS.CST_LCMADJUSTMENTS_PVT dependencies on GL_PERIOD_STATUSES

Line 584: gl_period_statuses gps,

580: gps.period_name,
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

Line 2715: gl_period_statuses gps,

2711: rcv_accounting_events rae,
2712: po_lines_all pol,
2713: po_line_locations_all poll,
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

Line 2763: gl_period_statuses gps,

2759: SELECT p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2760: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,
2761: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id
2762: FROM cst_lc_adj_interface clai,
2763: gl_period_statuses gps,
2764: cst_acct_info_v cai
2765: WHERE clai.group_id = p_group_id
2766: AND clai.process_status = 2
2767: AND clai.organization_id = p_organization_id