eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RECIPE_DETAIL_PVT dependencies on GMD_RECIPE_ORGN_RESOURCES

Line 1579: FROM gmd_recipe_orgn_resources

1575: vOprn_line_id NUMBER,
1576: vResources VARCHAR2,
1577: vOrgn_id NUMBER) IS
1578: SELECT rowid
1579: FROM gmd_recipe_orgn_resources
1580: where recipe_id = NVL(vRecipe_id,-1) AND
1581: RoutingStep_id = NVL(vRoutingStep_id,-1) AND
1582: oprn_line_id = NVL(vOprn_line_id,-1) AND
1583: resources = vResources AND

Line 1588: /* gmd_recipe_orgn_resources table */

1584: organization_id = vOrgn_id;
1585:
1586: BEGIN
1587: /* Updating recipe orgn resources for forst time infact insert a new record in */
1588: /* gmd_recipe_orgn_resources table */
1589:
1590: /* Initialization of all status */
1591: x_return_status := FND_API.G_RET_STS_SUCCESS;
1592:

Line 1609: INSERT INTO GMD_RECIPE_ORGN_RESOURCES (

1605: CLOSE recipe_resources_cur;
1606:
1607: /* ++++++++++++++++INSERTs+++++++++++++++++++++++++ */
1608: IF (l_dml_type = 'I') THEN
1609: INSERT INTO GMD_RECIPE_ORGN_RESOURCES (
1610: RECIPE_ID ,
1611: ORGANIZATION_ID ,
1612: ROUTINGSTEP_ID ,
1613: OPRN_LINE_ID ,

Line 1723: UPDATE GMD_RECIPE_ORGN_RESOURCES

1719: END IF; /* end of dml type */
1720:
1721: /* +++++++++++++++UPDATE+++++++++++++++++++++++++++ */
1722: IF (l_dml_type = 'U') THEN
1723: UPDATE GMD_RECIPE_ORGN_RESOURCES
1724: SET MIN_CAPACITY = p_recipe_detail_rec.min_capacity,
1725: MAX_CAPACITY = p_recipe_detail_rec.max_capacity,
1726: PROCESS_PARAMETER_5 = p_recipe_detail_rec.PROCESS_PARAMETER_5,
1727: PROCESS_PARAMETER_4 = p_recipe_detail_rec.PROCESS_PARAMETER_4,