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 2736: gl_period_statuses gps,

2732: /* Bug 13960596 po_lines_all pol, */
2733: rcv_shipment_lines rsl,
2734: po_line_locations_all poll,
2735: po_distributions_all pod,
2736: gl_period_statuses gps,
2737: cst_acct_info_v cai,
2738: mtl_parameters mp,
2739: mtl_system_items_b msi,
2740: rcv_parameters rp

Line 2785: gl_period_statuses gps,

2781: SELECT p_group_id, transaction_id, 'TRANSACTION_DATE', 'Purchasing Period is Closed or in the Future',
2782: fnd_global.user_id, SYSDATE, fnd_global.prog_appl_id, fnd_global.conc_program_id,
2783: SYSDATE, SYSDATE, fnd_global.login_id, fnd_global.user_id, fnd_global.conc_request_id
2784: FROM cst_lc_adj_interface clai,
2785: gl_period_statuses gps,
2786: cst_acct_info_v cai
2787: WHERE clai.group_id = p_group_id
2788: AND clai.process_status = 2
2789: AND clai.organization_id = p_organization_id