APPS.GMF_MIGRATION dependencies on SY_UOMS_MST

Line 1417: L_uom_code sy_uoms_mst.uom_code%TYPE;

1413: /************************
1414: * Local Variables *
1415: ************************/
1416:
1417: L_uom_code sy_uoms_mst.uom_code%TYPE;
1418:
1419: /****************
1420: * Cursors *
1421: ****************/

Line 1429: FROM sy_uoms_mst

1425: p_um_code IN VARCHAR2
1426: )
1427: IS
1428: SELECT uom_code
1429: FROM sy_uoms_mst
1430: WHERE um_code = p_um_code;
1431:
1432: BEGIN
1433:

Line 5402: FROM sy_uoms_mst x

5398: WHERE x.cost_mthd_code = a.cost_type_code
5399: ),
5400: a.cost_trans_um = (
5401: SELECT x.uom_Code
5402: FROM sy_uoms_mst x
5403: WHERE x.um_code = a.cost_trans_uom
5404: )
5405: WHERE (
5406: (a.cost_type_id IS NULL AND a.cost_type_code IS NOT NULL)

Line 5587: FROM sy_uoms_mst x

5583: ),
5584: a.item_uom
5585: = (
5586: SELECT x.uom_code
5587: FROM sy_uoms_mst x
5588: WHERE x.um_code = a.item_um
5589: ),
5590: a.resource_uom
5591: = (

Line 5593: FROM sy_uoms_mst y

5589: ),
5590: a.resource_uom
5591: = (
5592: SELECT y.uom_code
5593: FROM sy_uoms_mst y
5594: WHERE y.um_code = a.resource_um
5595: ),
5596: (
5597: a.organization_id,