[Home] [Help]
1209: l_last_billing_date date := null;
1210: l_consigned_billing_cycle number := null;
1211: l_invoice_close_tolerance number := null;
1212: l_item_inv_asset_flag
1213: mtl_system_items_b.inventory_asset_flag%TYPE := NULL;
1214: l_return_status varchar2(1) := NULL;
1215: l_msg_count number := NULL;
1216: l_msg_data varchar2(2000) := NULL;
1217: -- CONSIGNED FPI END
1319: -- check the org value from hr_locations to ensure
1320: -- that the item is defined in this org
1321: if (l_to_ship_to_organization_id is NOT NULL) then
1322: select count(*) into l_count from
1323: mtl_system_items where
1324: inventory_item_id=l_item_id and
1325: organization_id=l_to_ship_to_organization_id ;
1326: if (l_count=0) then
1327: l_to_ship_to_organization_id:=NULL;
1336: -- if the item is not defined for the FSP org, then
1337: -- leave the org null.
1338: if (l_to_ship_to_organization_id is NULL) then
1339: select count(*) into l_count from
1340: mtl_system_items where
1341: inventory_item_id=l_item_id and
1342: organization_id=x_inv_org_id;
1343: if (l_count <> 0) then
1344: l_to_ship_to_organization_id := x_inv_org_id;
1390:
1391: l_progress := '080';
1392:
1393: select count(*) into l_count from
1394: mtl_system_items where
1395: inventory_item_id=l_item_id and
1396: organization_id=l_to_ship_to_organization_id ;
1397:
1398: if (l_count=0) then
2746: l_accrue_on_receipt_flag varchar2(1);
2747: l_poll_receipt_required_flag varchar2(1);
2748:
2749: --
2750: l_secondary_default_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE ;
2751: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE ;
2752: l_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
2753: --
2754:
2747: l_poll_receipt_required_flag varchar2(1);
2748:
2749: --
2750: l_secondary_default_ind MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND%TYPE ;
2751: l_grade_control_flag MTL_SYSTEM_ITEMS.GRADE_CONTROL_FLAG%TYPE ;
2752: l_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
2753: --
2754:
2755: BEGIN