DBA Data[Home] [Help]

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 5425: FROM sy_uoms_mst x

5421: WHERE x.cost_mthd_code = a.cost_type_code
5422: ),
5423: a.cost_trans_um = (
5424: SELECT x.uom_Code
5425: FROM sy_uoms_mst x
5426: WHERE x.um_code = a.cost_trans_uom
5427: )
5428: WHERE (
5429: (a.cost_type_id IS NULL AND a.cost_type_code IS NOT NULL)

Line 5610: FROM sy_uoms_mst x

5606: ),
5607: a.item_uom
5608: = (
5609: SELECT x.uom_code
5610: FROM sy_uoms_mst x
5611: WHERE x.um_code = a.item_um
5612: ),
5613: a.resource_uom
5614: = (

Line 5616: FROM sy_uoms_mst y

5612: ),
5613: a.resource_uom
5614: = (
5615: SELECT y.uom_code
5616: FROM sy_uoms_mst y
5617: WHERE y.um_code = a.resource_um
5618: ),
5619: (
5620: a.organization_id,