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 1511: (select 1 from por_unit_of_measure_lov_v puomv

1507: select pht.line_number, pht.gross_weight_uom
1508: from pos_exasn_headers pht
1509: where pht.gross_weight_uom is not null
1510: and not exists
1511: (select 1 from por_unit_of_measure_lov_v puomv
1512: where puomv.unit_of_measure = pht.gross_weight_uom);
1513:
1514:
1515: --H3: NET WEIGHT UOM

Line 1522: (select 1 from por_unit_of_measure_lov_v puomv

1518: select pht.line_number, pht.net_weight_uom
1519: from pos_exasn_headers pht
1520: where pht.net_weight_uom is not null
1521: and not exists
1522: (select 1 from por_unit_of_measure_lov_v puomv
1523: where puomv.unit_of_measure = pht.net_weight_uom);
1524:
1525: --H4: TAR WEIGHT UOM
1526: cursor l_checkTarWtUOM_csr

Line 1532: (select 1 from por_unit_of_measure_lov_v puomv

1528: select pht.line_number, pht.tar_weight_uom
1529: from pos_exasn_headers pht
1530: where pht.tar_weight_uom is not null
1531: and not exists
1532: (select 1 from por_unit_of_measure_lov_v puomv
1533: where puomv.unit_of_measure = pht.tar_weight_uom);
1534:
1535: --H5: FREIGHT TERMS
1536: cursor l_checkFreightTerms_csr

Line 1593: from por_unit_of_measure_lov_v puomv

1589: --Convert Gross Weight UOM to code
1590: update pos_exasn_headers
1591: set gross_weight_uom =
1592: (select puomv.uom_code
1593: from por_unit_of_measure_lov_v puomv
1594: where gross_weight_uom is not null
1595: and gross_weight_uom = puomv.unit_of_measure);
1596:
1597: --H3

Line 1616: from por_unit_of_measure_lov_v puomv

1612: --Convert Net Weight UOM to code
1613: update pos_exasn_headers
1614: set net_weight_uom =
1615: (select puomv.uom_code
1616: from por_unit_of_measure_lov_v puomv
1617: where net_weight_uom is not null
1618: and net_weight_uom = puomv.unit_of_measure);
1619:
1620: --H4

Line 1639: from por_unit_of_measure_lov_v puomv

1635: --Convert Tar Weight UOM to code
1636: update pos_exasn_headers
1637: set tar_weight_uom =
1638: (select puomv.uom_code
1639: from por_unit_of_measure_lov_v puomv
1640: where tar_weight_uom is not null
1641: and tar_weight_uom = puomv.unit_of_measure);
1642:
1643: