APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on WSH_DELIVERY_DETAILS

Line 1325: FROM wsh_delivery_details

1321: l_exist_dd_count NUMBER := -1;
1322: BEGIN
1323: SELECT Count(*)
1324: INTO l_exist_dd_count
1325: FROM wsh_delivery_details
1326: WHERE source_line_id = l_changed_attributes(I).source_line_id
1327: AND source_code = 'OE'
1328: ;
1329: IF ( l_exist_dd_count > 0 ) THEN

Line 1332: FROM wsh_delivery_details wdd, oe_order_lines line

1328: ;
1329: IF ( l_exist_dd_count > 0 ) THEN
1330: SELECT Count(*)
1331: INTO l_non_cxl_dd_count
1332: FROM wsh_delivery_details wdd, oe_order_lines line
1333: WHERE wdd.source_line_id = line.line_id
1334: AND wdd.source_code = 'OE'
1335: AND wdd.source_line_id = l_changed_attributes(I).source_line_id
1336: AND Nvl(wdd.released_status, 'N') <> 'D'

Line 1482: FROM WSH_DELIVERY_DETAILS

1478: BEGIN
1479:
1480: SELECT COUNT(*)
1481: INTO l_cxl_dd_count
1482: FROM WSH_DELIVERY_DETAILS
1483: WHERE SOURCE_LINE_ID = l_changed_attributes(I).source_line_id
1484: AND SOURCE_CODE = 'OE'
1485: AND RELEASED_STATUS <> 'D';
1486:

Line 1983: FROM wsh_delivery_details

1979: IF p_line_rec.item_type_code = 'STANDARD' THEN
1980:
1981: SELECT count(*)
1982: INTO l_wdd_count
1983: FROM wsh_delivery_details
1984: WHERE source_line_id = p_line_rec.line_id
1985: AND released_status <> 'D'
1986: AND source_code = 'OE'
1987: AND oe_interfaced_flag = 'N';

Line 3383: FROM wsh_delivery_details

3379: BEGIN
3380:
3381: SELECT nvl(sum(shipped_quantity),0), requested_quantity_uom
3382: INTO l_shipped_quantity, l_requested_qty_uom
3383: FROM wsh_delivery_details
3384: WHERE source_line_id in
3385: (SELECT line_id
3386: FROM oe_order_lines
3387: WHERE line_set_id = l_line_rec.line_set_id

Line 5447: FROM WSH_DELIVERY_DETAILS

5443: BEGIN
5444:
5445: SELECT 'Line is Released , staged or confirmed..'
5446: INTO l_dummy
5447: FROM WSH_DELIVERY_DETAILS
5448: WHERE SOURCE_LINE_ID = l_line_tbl(l_line_index).line_id
5449: AND RELEASED_STATUS <> 'N';
5450:
5451:

Line 5740: -- FROM wsh_delivery_details

5736: AND open_flag = 'Y'
5737: AND shipped_quantity is NULL
5738: -- AND line_id not in
5739: -- (SELECT source_line_id
5740: -- FROM wsh_delivery_details
5741: -- WHERE released_status in ('Y', 'C')
5742: AND line_id in
5743: (SELECT source_line_id
5744: FROM wsh_delivery_details

Line 5744: FROM wsh_delivery_details

5740: -- FROM wsh_delivery_details
5741: -- WHERE released_status in ('Y', 'C')
5742: AND line_id in
5743: (SELECT source_line_id
5744: FROM wsh_delivery_details
5745: WHERE source_header_id = oe.header_id);
5746:
5747:
5748: --

Line 5772: FROM wsh_delivery_details

5768: LOOP
5769:
5770: SELECT count(*)
5771: INTO l_count
5772: FROM wsh_delivery_details
5773: WHERE source_line_id = line_rec.line_id
5774: AND released_status <> 'D';
5775:
5776: