DBA Data[Home] [Help]

APPS.WMS_ENGINE_PVT dependencies on PJM_ORG_PARAMETERS

Line 1780: FROM pjm_org_parameters

1776:
1777: CURSOR c_project_param IS
1778: SELECT allow_cross_proj_issues
1779: , allow_cross_unitnum_issues
1780: FROM pjm_org_parameters
1781: WHERE organization_id = l_request_line_rec.organization_id;
1782:
1783: -- 8809951 Modified Cursor
1784: CURSOR c_wip_reservations IS

Line 2513: -- from the table pjm_org_Parameters where

2509: END IF;
2510:
2511: -- Added to support PJM
2512: -- Query the columns ALLOW_CROSS_PROJ_ISSUES and ALLOW_CROSS_UNITNUM_ISSUES
2513: -- from the table pjm_org_Parameters where
2514: -- If ALLOW_CROSS_PROJ_ISSUES is Y, then set project and task to NULL
2515: -- for picks only.
2516: -- If ALLOW_CROSS_UNITNUM_ISSUES is Y, set the unit_number to NULL.
2517: -- BUG 2880682 : Treating null project/task as common project/task and forcing