[Home] [Help]
657: AND pll.line_location_id = v_line_location_id
658: AND NVL(pll.approved_flag, 'N') = 'Y'
659: AND NVL(pll.cancel_flag, 'N') = 'N'
660: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
661: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT');
662:
663: default_po_info shipments%ROWTYPE;
664: BEGIN
665: IF (g_asn_debug = 'Y') THEN
3223: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
3224: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
3225: OR ( NVL(x_include_closed_po, 'N') = 'N'
3226: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
3227: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
3228: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
3229: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
3230: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'))
3231: ORDER BY NVL(pll.promised_date, Nvl(pll.need_by_date,pll.creation_date)), Nvl(pll.need_by_date,pll.creation_date), pll.creation_date; --bug10022180
3256: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
3257: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
3258: OR ( NVL(x_include_closed_po, 'N') = 'N'
3259: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
3260: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
3261: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
3262: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
3263: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'));
3264:
3339: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
3340: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
3341: OR ( NVL(x_include_closed_po, 'N') = 'N'
3342: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
3343: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
3344: AND pod.distribution_num = NVL(v_distribution_num, pod.distribution_num)
3345: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
3346: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
3347: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'))
3386: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
3387: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
3388: OR ( NVL(x_include_closed_po, 'N') = 'N'
3389: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
3390: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
3391: AND pll.ship_to_organization_id = NVL(v_ship_to_org_id, pll.ship_to_organization_id)
3392: AND pll.ship_to_location_id = NVL(v_ship_to_location_id, pll.ship_to_location_id)
3393: AND NVL(pl.vendor_product_num, '-999') = NVL(v_vendor_product_num, NVL(pl.vendor_product_num, '-999'));
3394:
4527: rcv_error_pkg.set_token('NUMBER', temp_cascaded_table(current_n).document_shipment_line_num);
4528: rcv_error_pkg.log_interface_error('DOCUMENT_SHIPMENT_LINE_NUM', FALSE);
4529: END IF;
4530:
4531: IF x_shipment_type NOT IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT') THEN
4532: IF (g_asn_debug = 'Y') THEN
4533: asn_debug.put_line('This PO shipment type cannot be received');
4534: END IF;
4535:
5931: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
5932: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
5933: OR ( NVL(x_include_closed_po, 'N') = 'N'
5934: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
5935: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
5936: ORDER BY NVL(pll.promised_date, pll.need_by_date);
5937:
5938: CURSOR count_shipments(
5939: v_po_line_id NUMBER,
5954: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
5955: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
5956: OR ( NVL(x_include_closed_po, 'N') = 'N'
5957: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
5958: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT');
5959:
5960: CURSOR distributions(
5961: v_po_line_id NUMBER,
5962: v_po_line_location_id NUMBER,
6014: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
6015: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
6016: OR ( NVL(x_include_closed_po, 'N') = 'N'
6017: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
6018: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT')
6019: ORDER BY NVL(pll.promised_date, pll.need_by_date);
6020:
6021: CURSOR count_distributions(
6022: v_po_line_id NUMBER,
6041: AND ( ( NVL(x_include_closed_po, 'N') = 'Y'
6042: AND NVL(pll.closed_code, 'OPEN') <> 'FINALLY CLOSED')
6043: OR ( NVL(x_include_closed_po, 'N') = 'N'
6044: AND (NVL(pll.closed_code, 'OPEN') NOT IN('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING'))))
6045: AND pll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT');
6046:
6047: /*
6048: ** Debug: had to change this to the distribution record
6049: ** Might be a compatibility issue between the two record definitions
6745: rcv_error_pkg.set_token('NUMBER', temp_cascaded_table(current_n).document_shipment_line_num);
6746: rcv_error_pkg.log_interface_error('DOCUMENT_SHIPMENT_LINE_NUM', FALSE);
6747: END IF;
6748:
6749: IF x_shipment_type NOT IN('STANDARD', 'BLANKET', 'SCHEDULED','PREPAYMENT') THEN
6750: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
6751: rcv_error_pkg.set_error_message('RCV_ASN_INVAL_SHIPMT_TYPE', x_cascaded_table(n).error_message);
6752: rcv_error_pkg.set_token('NUMBER', temp_cascaded_table(current_n).document_shipment_line_num);
6753: rcv_error_pkg.log_interface_error('DOCUMENT_SHIPMENT_LINE_NUM', FALSE);
7909: END IF;
7910:
7911: IF ( x_cascaded_table(n).transaction_type = 'RECEIVE'
7912: AND NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') = 'DELIVER') THEN
7913: /* 1 is Standard Receipt, 2 is Inspection Required */
7914: IF ( (x_cascaded_table(n).routing_header_id) IN(1, 2)
7915: AND NVL(rcv_setup_s.get_override_routing, 'N') = 'N') THEN
7916: rcv_error_pkg.set_error_message('RCV_ASN_DELIVER_ROUTING_FAILED');
7917: RAISE e_validation_error;
11747: */
11748: IF ( (temp_cascaded_table(1).transaction_type = 'DELIVER')
11749: AND (l_num_of_distributions > 1)) THEN --{
11750: IF (g_asn_debug = 'Y') THEN
11751: asn_debug.put_line('before getting available qty for standard multi distributions deliver ');
11752: END IF;
11753:
11754: --
11755: get_clm_info('QUANTITY',
12368: x_converted_parent_trx_qty := 0;
12369: END IF;
12370:
12371: IF (g_asn_debug = 'Y') THEN
12372: asn_debug.put_line('Available qty for standard multiple distributions deliver ' || x_converted_parent_trx_qty);
12373: asn_debug.put_line('l_converted_distribution_qty ' || l_converted_distribution_qty);
12374: asn_debug.put_line('l_converted_transaction_qty ' || l_converted_transaction_qty);
12375: END IF;
12376: END IF; --}