APPS.POS_EXCELASN_PVT dependencies on POR_UNIT_OF_MEASURE_LOV_V

Line 809: (select 1 from por_unit_of_measure_lov_v puomv

805: is
806: select plnt.line_number, plnt.uom
807: from pos_exasn_lines plnt
808: where not exists
809: (select 1 from por_unit_of_measure_lov_v puomv
810: where puomv.unit_of_measure = plnt.uom);
811:
812: --L2: Country of Origin
813: cursor l_checkCountryOO_csr

Line 1441: (select 1 from por_unit_of_measure_lov_v puomv

1437: select pht.line_number, pht.gross_weight_uom
1438: from pos_exasn_headers pht
1439: where pht.gross_weight_uom is not null
1440: and not exists
1441: (select 1 from por_unit_of_measure_lov_v puomv
1442: where puomv.unit_of_measure = pht.gross_weight_uom);
1443:
1444:
1445: --H3: NET WEIGHT UOM

Line 1452: (select 1 from por_unit_of_measure_lov_v puomv

1448: select pht.line_number, pht.net_weight_uom
1449: from pos_exasn_headers pht
1450: where pht.net_weight_uom is not null
1451: and not exists
1452: (select 1 from por_unit_of_measure_lov_v puomv
1453: where puomv.unit_of_measure = pht.net_weight_uom);
1454:
1455: --H4: TAR WEIGHT UOM
1456: cursor l_checkTarWtUOM_csr

Line 1462: (select 1 from por_unit_of_measure_lov_v puomv

1458: select pht.line_number, pht.tar_weight_uom
1459: from pos_exasn_headers pht
1460: where pht.tar_weight_uom is not null
1461: and not exists
1462: (select 1 from por_unit_of_measure_lov_v puomv
1463: where puomv.unit_of_measure = pht.tar_weight_uom);
1464:
1465: --H5: FREIGHT TERMS
1466: cursor l_checkFreightTerms_csr

Line 1523: from por_unit_of_measure_lov_v puomv

1519: --Convert Gross Weight UOM to code
1520: update pos_exasn_headers
1521: set gross_weight_uom =
1522: (select puomv.uom_code
1523: from por_unit_of_measure_lov_v puomv
1524: where gross_weight_uom is not null
1525: and gross_weight_uom = puomv.unit_of_measure);
1526:
1527: --H3

Line 1546: from por_unit_of_measure_lov_v puomv

1542: --Convert Net Weight UOM to code
1543: update pos_exasn_headers
1544: set net_weight_uom =
1545: (select puomv.uom_code
1546: from por_unit_of_measure_lov_v puomv
1547: where net_weight_uom is not null
1548: and net_weight_uom = puomv.unit_of_measure);
1549:
1550: --H4

Line 1569: from por_unit_of_measure_lov_v puomv

1565: --Convert Tar Weight UOM to code
1566: update pos_exasn_headers
1567: set tar_weight_uom =
1568: (select puomv.uom_code
1569: from por_unit_of_measure_lov_v puomv
1570: where tar_weight_uom is not null
1571: and tar_weight_uom = puomv.unit_of_measure);
1572:
1573: