APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on WSH_DELIVERY_DETAILS

Line 1320: FROM wsh_delivery_details

1316: l_exist_dd_count NUMBER := -1;
1317: BEGIN
1318: SELECT Count(*)
1319: INTO l_exist_dd_count
1320: FROM wsh_delivery_details
1321: WHERE source_line_id = l_changed_attributes(I).source_line_id
1322: AND source_code = 'OE'
1323: ;
1324: IF ( l_exist_dd_count > 0 ) THEN

Line 1327: FROM wsh_delivery_details wdd, oe_order_lines line

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

Line 1477: FROM WSH_DELIVERY_DETAILS

1473: BEGIN
1474:
1475: SELECT COUNT(*)
1476: INTO l_cxl_dd_count
1477: FROM WSH_DELIVERY_DETAILS
1478: WHERE SOURCE_LINE_ID = l_changed_attributes(I).source_line_id
1479: AND SOURCE_CODE = 'OE'
1480: AND RELEASED_STATUS <> 'D';
1481:

Line 1979: FROM wsh_delivery_details

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

Line 3371: FROM wsh_delivery_details

3367: BEGIN
3368:
3369: SELECT nvl(sum(shipped_quantity),0), requested_quantity_uom
3370: INTO l_shipped_quantity, l_requested_qty_uom
3371: FROM wsh_delivery_details
3372: WHERE source_line_id in
3373: (SELECT line_id
3374: FROM oe_order_lines
3375: WHERE line_set_id = l_line_rec.line_set_id

Line 5427: FROM WSH_DELIVERY_DETAILS

5423: BEGIN
5424:
5425: SELECT 'Line is Released , staged or confirmed..'
5426: INTO l_dummy
5427: FROM WSH_DELIVERY_DETAILS
5428: WHERE SOURCE_LINE_ID = l_line_tbl(l_line_index).line_id
5429: AND RELEASED_STATUS <> 'N';
5430:
5431:

Line 5715: -- FROM wsh_delivery_details

5711: AND open_flag = 'Y'
5712: AND shipped_quantity is NULL
5713: -- AND line_id not in
5714: -- (SELECT source_line_id
5715: -- FROM wsh_delivery_details
5716: -- WHERE released_status in ('Y', 'C')
5717: AND line_id in
5718: (SELECT source_line_id
5719: FROM wsh_delivery_details

Line 5719: FROM wsh_delivery_details

5715: -- FROM wsh_delivery_details
5716: -- WHERE released_status in ('Y', 'C')
5717: AND line_id in
5718: (SELECT source_line_id
5719: FROM wsh_delivery_details
5720: WHERE source_header_id = oe.header_id);
5721:
5722:
5723: --

Line 5747: FROM wsh_delivery_details

5743: LOOP
5744:
5745: SELECT count(*)
5746: INTO l_count
5747: FROM wsh_delivery_details
5748: WHERE source_line_id = line_rec.line_id
5749: AND released_status <> 'D';
5750:
5751: