[Home] [Help]
1329: l_last_billing_date date := null;
1330: l_consigned_billing_cycle number := null;
1331: l_invoice_close_tolerance number := null;
1332: l_item_inv_asset_flag
1333: mtl_system_items_b.inventory_asset_flag%TYPE := NULL;
1334: l_return_status varchar2(1) := NULL;
1335: l_msg_count number := NULL;
1336: l_msg_data varchar2(2000) := NULL;
1337: -- CONSIGNED FPI END
1448: -- check the org value from hr_locations to ensure
1449: -- that the item is defined in this org
1450: if (l_to_ship_to_organization_id is NOT NULL) then
1451: select count(*) into l_count from
1452: mtl_system_items where
1453: inventory_item_id=l_item_id and
1454: organization_id=l_to_ship_to_organization_id ;
1455: if (l_count=0) then
1456: l_to_ship_to_organization_id:=NULL;
1465: -- if the item is not defined for the FSP org, then
1466: -- leave the org null.
1467: if (l_to_ship_to_organization_id is NULL) then
1468: select count(*) into l_count from
1469: mtl_system_items where
1470: inventory_item_id=l_item_id and
1471: organization_id=x_inv_org_id;
1472: if (l_count <> 0) then
1473: l_to_ship_to_organization_id := x_inv_org_id;
1519:
1520: l_progress := '080';
1521:
1522: select count(*) into l_count from
1523: mtl_system_items where
1524: inventory_item_id=l_item_id and
1525: organization_id=l_to_ship_to_organization_id ;
1526:
1527: if (l_count=0) then
3079: l_accrue_on_receipt_flag varchar2(1);
3080: l_poll_receipt_required_flag varchar2(1);
3081:
3082: --
3083: l_secondary_default_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE ;
3084: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE ;
3085: l_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
3086: --
3087:
3080: l_poll_receipt_required_flag varchar2(1);
3081:
3082: --
3083: l_secondary_default_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE ;
3084: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE ;
3085: l_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
3086: --
3087:
3088: BEGIN